DZone 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

Michael has posted 2 posts at DZone. View Full User Profile

Sql Drupal Last Log With Date

02.28.2007
| 2158 views |
  • submit to reddit
        // 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