Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- MySQL - Group By Problem


LifeinAsia - 5:13 pm on Sep 13, 2010 (gmt 0)


Because of "GROUP BY pcid" (I assume you meant pic_id?).
You need to use "GROUP BY pic_cat" to get the latest date for each pic_cat.


Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4201161.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com