Sql Drupal Last Log With Date
Join the DZone community and get the full member experience.Join For Free
// 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
Opinions expressed by DZone contributors are their own.