little help with stored procedure call

[m m]

Hi,

I'm calling a stored procedure from a PHP script - which works - but then all subsequent SQL queries fail with the message:

"Lost connection to MySQL server during query"

My procedure runs fine in the MySql prompt, it just does something simple for testing like SELECT COUNT(*) AS something FROM my_table.

Then my PHP script looks like:


$result = mysqli_query($conn, "call sp_FirstTry()");
if (!$result) {
return "Failed executing stored proc: [" . mysqli_error($conn) . "]";
}

// Fails on this next call?
$result = mysqli_query($conn, "SELECT * FROM my_table");
if (!$result) {
return "Failed on next SQL interaction!?!?!?: [" . mysqli_error($conn) . "]";
}

Any ideas what's going on?

Thanks