Never been to DZone Snippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

About this user

« Newer Snippets
Older Snippets »
Showing 1-2 of 2 total  RSS 

sql drupal count login

// description of your code here

SELECT u.name name, count(name) anzahl         
    FROM accesslog al, users u
    where al.uid = u.uid group by name order by anzahl
to sql drupal by stereosonic on Feb 28, 2007

sql drupal last log with date

// description of your code here

  SELECT u.name name,
      DATE(FROM_UNIXTIME(al.timestamp)) ladate
    
    FROM accesslog al, users u
    where al.uid = u.uid order by ladate desc
to sql drupal by stereosonic on Feb 28, 2007
« Newer Snippets
Older Snippets »
Showing 1-2 of 2 total  RSS