I'm connecting to an access database and I would like the query to
return results grouped on a particular column. When I try the following
query, I get this error back from PHP:
DB Error: syntax Error

"SELECT * FROM HardwareInstallationsSummary WHERE LocationID = $loc_ID
GROUP BY Manufacturer"

Iposted this question on a PHP list and someone there suggested that SQl
does not allow this to happen unless its part of an aggregate statement.
Is this true? Is there a way around this?
TIA