2014 Commands out of sync; you can't run this command now

Hello All,

I was searching for a response about this topic but none get the right
answare, I hope i get help from you on this. :)

I trying to do an insert using a stored procedure to rely the charge
on the db but every type I run the call from my web page ussing PHP
5.X I get the same error.

This is what I'm doing:
__________________________________________________ ____________________________________________
$link = mysql_connect( DB_HOST, DB_USER, DB_PASSWORD, true, 131074);
mysql_select_db(DB_NAME);

$sql = "call spTestCreate('" .
trim($Value1) . "', '" .
trim($Value2) . "', '" .
trim($Value3) . "', " .
$Value4 . ", " .
$Value5 . ", '" .
trim($Value6) . "', '" .
trim($Value7) . "', '" .
trim($Value8) . "') ; ";

$res = mysql_query($sql);

if (!$res) {
echo "Could not successfully run query (" . $sql . ") from DB: " .
mysql_error();
} else {
$row = mysql_fetch_row($res);
$LastId = $row[0];
}
__________________________________________________ ____________________________________________

If I run the call from the SQLyog or any other tool it runs prefect
but that's not the case in the PHP.

Any Idea or Solution is welcome.

Thanks!

re: 2014 Commands out of sync; you can't run this command now

yaguirre@gmail.com wrote:do an echo($sql) or print($sql) and post the results in here.

re: 2014 Commands out of sync; you can't run this command now

On Jul 25, 11:14 am, lark <ham...@sbcglobal.netwrote:The result of the echo is the next:

call spTestCreate('myself', 'value2', 'value3', 56, 0, 'value6',
'value7', '7818ec0361') ;

re: 2014 Commands out of sync; you can't run this command now

On Jul 25, 11:23 am, "yagui...@gmail.com" <yagui...@gmail.comwrote:One more thing to say from my side is that all the select queries are
running fine and no errors so far. just in this kind of queries.

Hope you find guys could help me.

TIA.

re: 2014 Commands out of sync; you can't run this command now

Chainsaw [cr] wrote:what is the data type of the fields that correspond to values "56" and "0"?



--
lark -- hamzee@sbcdeglobalspam.net
To reply to me directly, delete "despam".

re: 2014 Commands out of sync; you can't run this command now

On Jul 25, 2:56 pm, lark <ham...@sbcglobal.netwrote:Those fields are int(11);

FYI The other stored procedures run OK, only this and others with the
same insert and last_insert_id() has the problems.

TIA.

re: 2014 Commands out of sync; you can't run this command now

Chainsaw [cr] wrote:make sure that the user that is logged in through your php application
has execute privilege in the database where the stored procedure is
declared.

re: 2014 Commands out of sync; you can't run this command now

On Jul 25, 7:20 pm, lark <ham...@sbcglobal.netwrote:I did check the user access rights and has all the options granted but
still getting the same error. "Commands out of sync; you cannot run
this command now "
I still no have a clue around this.

re: 2014 Commands out of sync; you can't run this command now

The stored procedure is built to do :

1- insert into a table
2- get last id inserted and return it in a select statement ( select
last_inserted_id(); )

And the PHP is located in to computers the first is a 5.2.3 which is
the Dev Server and other is an 5.2.0-8 in the Production server but so
far both has the same problem.

Thanks for all the help.