PHP, Stored Procedures and MS SQL

[pnathan]

Ok, I got a interesting problem.

I currently have a number of stored procedures that I pass paramaters to. Everything is working fine, however, there are certain parameters that I cannot pass to these Stored Procedures:

$Query_wp = ("EXECUTE sp_Product_All $ID");
$Result_wp=mssql_query($Query_wp);
$Row_wp = mssql_fetch_object($Result_wp); 

Now say from the Query above, I get the following variable:

$Row_wp->Web_Product 

Everything is cool, but then I have a problem when I try to envoke my Stored Procedure:

[sql]
CREATE PROCEDURE sp_Product_All @Row_wp->Product int
AS
SELECT ID, Articlenumber, Web_Name, Image FROM Product
WHERE ID=@Row_wp->Product
GO
[/sql]

I am getting an syntax error for @Row_wp->Product. I have tried variations of this syntax, but no joy. Any suggestions?

Thanks.