What's wrong ?

[brocky]

I am trying to execute a Stored Procedure...

my SP is correct... but I always get the Die message; WRONG... My connection also works..

Here is my code...

$strQuery = "sp_update_product '".$ProdID."','".$txtProductName."','".$SupplierID."','".$ProdCategoryId."','".$txtQuantityPerUnit."','".$txtUnitprice."','".$txtUnitsinstock."','".$txtUnitsonorder."','".$txtReorderlevel."'";
echo $strQuery."<br>";
mssql_query($strQuery) or die ("WRONG");

What's wrong ???

[gernot]

instead of

mssql_query($strQuery) or die ("WRONG");

try:

mysql_query($strQuery) or die ("WRONG");

:-))

[brocky]

it also did not work..

I'm working with a microsoft database
so

MS should be correct

[Anon]

columns that are registered as numbers (INTEGER, DOUBLE, etc) do not get entered with sigle quotes around them - you have single quotes aroung EVERYTHING - e.g. ('".$ProdID."') elminate the single quotes where neccessary and it should work.