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 Deimel

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

Sql Drupal Last Log With Date

02.28.2007

| 1936 views |

        // 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

Tags: