Ordering results from Group by

[corvinedesign]

here is my select statement

SELECT * FROM gallery WHERE type='$type' GROUP BY topic ORDER BY date

this does not work. Here is what I need to do. I need to get all entries where type= type, then I need to group the returned rows by the topic field and then display the most recent entry in the group. right now it is displaying the oldest entry when I do a statement like this.
SELECT * FROM gallery WHERE type='$type' GROUP BY topic

any help or is there another way to order the whole and then group after. i am lost. thanks in advance.

[rrijnders]

What is the schema of the table?

Typically the GROUP BY clause is used when you are aggregating information, not for sequencing / ordering.

Post the schema of the table and I will help you out.