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