I cannot seem to get group by and order by to give the result I want. The way i have it below it returns the group by correctly but the order by is wrong. Kinda hard to explain but I am getting the first record from each cls_mem_id in the ascending order of the record in the database then the order by does order those records by cls_entry_date DESC. What I need is to get the last record entered by each cls_mem_id then order those records by cls_entry_date DESC.
GROUP BY classifieds.cls_mem_id ORDER BY cls_entry_date DESC