|
Posted by Lorenzo Thurman on 06/02/06 20:15
I'm using PHP 5 to make an ODBC connection to an MS Access database
using PEAR and I'm getting DB Error: Syntax Error when using the GROUP
BY clause. Here's my query:
SELECT * FROM HardwareInstallationsSummary WHERE LocationID = $loc_ID
GROUP BY EquipmentTypeID
Just for kicks, I changed the GROUP BY to ORDER BY. The query works, and
the items are sorted as expected, but this is not what I want. Is there
a bug in here somewhere?
TIA
Navigation:
[Reply to this message]
|