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

« Newer Snippets
Older Snippets »
Showing 11-12 of 12 total

sql drupal count login

// description of your code here

   1  
   2  SELECT u.name name, count(name) anzahl         
   3      FROM accesslog al, users u
   4      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

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