Group by problem

[dkin]

I am trying to use group by but whenever I run the page only 3 rows are displayed, 1 of each type.

This is my code

$result = mysql_query("SELECT * FROM programs group by type order by name desc", $link) or die ("query 1: " . mysql_error());

I dont know whats wrong.

Someone help.

[dcrombie]

GROUP doesn't do what you think it does ;)

Try this query instead:

SELECT * FROM programs order by type, name desc;