PHP Commands out of sync, you can't run this command now

[Rahul Dubal]

hi,

I'm using php and mysql veriosn '5.0.51' and we are executing two stored procedures , first stored procedure works fine and the when we execute the second stroed procedure it throws this error.
We are using mysql_connect to DB .
Please help

Here is the connection info
$db = mysql_connect($host,$user,$pass,true,131074) or die("could not connect:".mysql_error($db));
-----------------------------------

$query_statement = "call GetSubState($account_id,'$date_limit','$state')";

$result = mysql_query ( $query_statement );

if (!$result) { die ("GetData : " . mysql_error() . "SQL: $query_statement"); }

$numrows = mysql_num_rows($result,$db);

if ($numrows==0) { return array(); }

for ($i=$start; $i < $numrows; $i++) {
unset($row);
foreach ($fields as $field) {
$row[$field] = mysql_result($result, $i, "$field");
}
$rows[] = $row;
}
mysql_free_result( $result);



Edited 1 time(s). Last edit at 09/29/2008 09:12PM by Rahul Dubal.