ODBC GroupBy

[NZ_Kiwis]

I'm trying to do a search and have it sorted by GroupBy but it does not work

Any ideas why?

$query = "SELECT * FROM StaffD Group By EmpNum";
	$result = odbc_exec($connection, $query);
	while(odbc_fetch_row($result)){

[DaveRandom]

Do ORDER BY x GROUP BY y might help?

Anything useful from odbc_errormsg() ?