Page is a not externally linkable
- Code, Content, and Presentation
---- MySQL query - group by needed or something else?
enigma1 - 3:24 pm on Oct 5, 2010 (gmt 0)Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4211460.htm
try order and limit
$mods_query = "select ab.id, ab.name, cd.year from employees ab, employee_reviews cd where ab.id=cd.employee_id and ab.current=1 order by cd.year desc limit 1"
Brought to you by WebmasterWorld: http://www.webmasterworld.com