ORDER BY ManufacturerName ASC
GROUP BY ManufacturerName
I get this when I used the group by "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY ManufacturerName' at line 1"
*EDIT Nevermind fixed it, I just needed to put it before the ORDER BY.
Thanks Jason YOU ARE A TREMENDOUS HELP