Trying to execute a stored procedure within PHP

[Joecool]

Here is my statement:

mssql_query("exececute PR_StoredProcedure('$ARG01','$ARG02','$ARG03','$AR G04','$ARG05','$ARG06','$ARG07','$ARG08','$ARG09', '$ARG10','$ARG11','$ARG12','$ARG13','$ARG14')");

I get the following when it is executed(asdf1 = $ARG01):

Incorrect syntax near 'asdf1'.

What is the syntax error? Without the ' it says near ','
Thanks for your help.

-Joe

[sdives]

Can you show the stored procedure? The message appears to indicate that it doesn't like the syntax of the sp, not the string you're trying to execute.

Sidney Ives
Database Administrator
Sentara Healthcare

[Joecool]

The procedure works fine through the query analizer. I am interested in seeing sample code on using a stored procedure with multiple perameters through PHP. From what I can tell, it doesnt like using more than one perameter. It is not as easy as using the query analizer.

-Joe