Re: [PHP] group by on mssql_query

On Thu, Feb 14, 2008 at 4:00 PM, [EMAIL PROTECTED] wrote: $ford = mssql_query(SELECT name FROM Table GROUP BY name); What do you see when you replace the above line with this? $ford = mssql_query(SELECT name FROM Table GROUP BY name) or die(mssql_get_last_message()); -- /Dan Daniel P.

Re: [PHP] group by on mssql_query

Column 'location_city.dst' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. Not fimilar with MSSQL to be honest. On Thu, Feb 14, 2008 at 4:00 PM, [EMAIL PROTECTED] wrote: $ford = mssql_query(SELECT name FROM Table GROUP BY

Re: [PHP] group by on mssql_query

Sweet Mother it just clicked. I got it thank you dan. On Thu, Feb 14, 2008 at 4:00 PM, [EMAIL PROTECTED] wrote: $ford = mssql_query(SELECT name FROM Table GROUP BY name); What do you see when you replace the above line with this? $ford = mssql_query(SELECT name FROM Table GROUP BY name)

Re: [PHP] group by on mssql_query

On Thu, Feb 14, 2008 at 4:13 PM, [EMAIL PROTECTED] wrote: Column 'location_city.dst' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. Not fimilar with MSSQL to be honest. Yes, MS SQL is strict and will not allow you to return