MSSQL vs MySQL - Syntax

[obrienkev]

Hi all,

What is the proper way of using the below query for MSSQL Server?

$result = mysql_query($query) or die(mysql_error());

Thanks.

Kevin.

Can someone please move this thread to PHP forum.
Thanks.

[longneck]

you'll probably get a better answer in the PHP forum.

[nico7799]

I think:
$result = mssql_query($query) or die(mssql_error());

Nicolas

[obrienkev]

mssql_error() isn't listed on PHP.net as an SQL Server function.

[nico7799]

Right, i didn't see it listed in php.net, but i did see it in some of the User Contributed Notes of php.net.
mssql_query() is listed though.