Ciao a tutti, sto provando ad avere da php un risultato di una storeprocedure
Codice PHP:
// Connect to SQL Server and check for errors$conn = mssql_connect($db_host,$db_user,$db_password);if ($conn===false){ echo '<p>Cannot connect to SQL Server Database. Please try again later.</p>'; exit;}if (mssql_select_db("miodatabase",$conn) === false) { echo '<p>Cannot connect to MyDatabase. Please try again later.</p>'; exit;}$proc = mssql_init('mai_proc',$conn);
if ($result = mssql_execute($proc)) { if ($row = mssql_fetch_row($result)) { // now you can deal with the $row array to check out your results }}
ma ottengo sempre un errore
Warning: mssql_execute() [function.mssql-execute]: message: Incorrect syntax near ','. (severity 15) in /home/camicie/public_html/documenti/Pivot2.php on line 23
Warning: mssql_execute() [function.mssql-execute]: General SQL Server error: Check messages from the SQL Server (severity 15) in /home/camicie/public_html/documenti/Pivot2.php on line 23
Warning: mssql_fetch_row() expects parameter 1 to be resource, boolean given in /home/camicie/public_html/documenti/Pivot2.php on line 25
secondo voi perchè?