Re: group by on mssql_query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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,  <admin@xxxxxxxxxxxxxxxxxxx> 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. Brown
Senior Unix Geek
<? while(1) { $me = $mind--; sleep(86400); } ?>

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux