Problem calling more than 1 stored procedure - please help

[lewisdow123]

Hi,

 

I've had this error for more than one week and I am hoping someone can help me big time.

 

I get the error: Error calling SPCommands out of sync; you can't run this command now

 

Every time I call more than one stored procedure...  It is always on the second stored procedure call that I get this error.

I have had one line answers to this error in the past and have tried these solutions given but they do not seem to work.

 

Would some one be kind enough to re-write the block of code so that it works.  I am essentially looking for an answer which will work for sure rather than links that will lead me off course again.... PLEASE HELP

 

I have also included my actual script if you want to see it.... btw the first connection works, just not the second.

 

 

Thank you

 

 

// First call to SP
$page = 2;
$section = 1;

include("DatabaseConnection.php"); //general connection - works fine

$sql = 'CALL GetPageContent("'.$page.'", "'.$section.'")';

$result = mysqli_query($conn, $sql) or die('Error calling SP' .mysqli_error($conn));

while($row=mysqli_fetch_assoc($result))
{
   // DO STUFF< REMOVED TO MAKE READING CLEARER
}

mysqli_free_result($result);

//SECOND CALL BELOW


$section = 2; // change parameter for different results

$sql = 'CALL GetPageContent("'.$page.'", "'.$section.'")';

$result = mysqli_query($conn, $sql) or die('Error calling SP' .mysqli_error($conn));


while($row=mysql_fetch_assoc($result))
{
   // DO STUFF< REMOVED TO MAKE READING CLEARER
}

18478_.php