Ordering & Grouping with MSSQL

This message was sent from Geocrawler.com by "Alistair McFadyen" <amcfadyen@mail.com> Be sure to reply to that address. I'd be grateful if anyone has seen this problem before and can help out. I'm connecting to a MS SQL database using the PHP Library. ODBC connection is fine most of the time, but the connection will not allow me to include an 'ORDER BY' or 'GROUP BY' clause in select statements; it doesn't case an odbc error, I just get no records returned when I try running the query. It's very frustrating when you can only get records out in the order your users entered them! Can any one help? Thanks in advance. Alistair Geocrawler.com - The Knowledge Archive