Re: [PHP] group by on mssql_query

2008-02-14 Thread Andrew Ballard
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

Re: [PHP] group by on mssql_query

2008-02-14 Thread admin
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

Re: [PHP] group by on mssql_query

2008-02-14 Thread admin
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

2008-02-14 Thread Daniel Brown
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()); -- Daniel P.

[PHP] group by on mssql_query

2008-02-14 Thread admin
$ford = mssql_query("SELECT name FROM Table GROUP BY name"); while($mustang = mssql_fetch_array($ford)) { echo $mustang['name'] . "/n"; } OS 2003 Server PHP 5.2.5 Apache 2.2.8 SQL 2000 For some reason it is NOT clicking what I am missing here. Second set of eyes please -- PHP General Maili