INSERT INTO mssql table

[krayz]

Hi,

I have been trying to insert few values in a MSSQL 2000 databse table but it would always fail. Surprisingly it would run smooth in MySQL.

The code is:

$query_insert="INSERT INTO simple(number) values ('1')";

	if(mssql_query($query_insert))
		 echo "successful";
	 else
		{
		 echo "failure";
		 exit();
		}

Any help would be highly appreciated.

Thanks

-KraYz