count won't work!

[obscurr]

hi!

this query works with the SQL Server Query Analyzer (ms sql server 7) :

SELECT produktnr, COUNT(produktnr) AS antall FROM bestilling GROUP BY produktnr

but it does not work in my php code :

$query4 = "SELECT produktnr, COUNT(produktnr) AS antall FROM bestilling GROUP BY produktnr";
$result4 = mssql_query($query4) or DIE("<br>SOMETHING WENT WRONG HERE...");

anybody knows why?
thanks

obscurr

[phpmoron]

Having the error that is produced to your screen would really help. Try this as your result:

$result4 = mssql_query($query4) or DIE( mysql_error() ); 

I hope that helps,
phpmoron

[obscurr]

but there aren't a mssql.error() funtion with Microsoft SQL server??? i think you referred to mysql...

is there a way to view error with mssql? Couldn't find any suitable functions in the manual..

obscurr

[jc94062]

You said the query works in "SQL Server Query Analyzer" so do the below and then test the output in the above (I assume its like phpMyAdmin)

$sql = "SELECT produktnr, COUNT(produktnr) AS antall FROM bestilling GROUP BY produktnr"
$query = mssql_query($sql);
if (!$query)
{
echo "Error: ".$sql;
}

Give that a shot.