melar09 - 5:23 pm on Sep 13, 2010 (gmt 0)
Yeah sorry I forgot to change the value it is pic_cat pcid is the actual column name for cat id saved with the pics. I have also been experimenting with outer/inner joins to no avail.
And this also doesn't work as I have tried it.
SELECT DISTINCT(pic_cat), pic_id, pic_timestamp
ORDER BY pic_timestamp DESC
It returns a result of all the rows ordered by the timestamp