[PHP/MySQL] Multiple Stored Procedures Using a Single Connection

camelCase

The Case of the Mysterious Camel.
Reaction score
362
For a PHP page, if I call a stored procedure, my page loads fine.
However, the moment I go for two or more stored procedures, the page refuses to load properly and there are no error messages.

I've been doing something like:
Code:
$result1 = $conn->query("CALL SP($stuff);");
$row1 = $result->fetch_assoc();

$result2 = $conn->query("CALL SP2($stuff);");
$row2 = $result->fetch_assoc();

Calling just SP1 or SP2 on their own is fine.
Calling both SP1 and SP2 (And other stored procedures) in one page bugs =/
 
General chit-chat
Help Users
  • No one is chatting at the moment.

      The Helper Discord

      Staff online

      Members online

      Affiliates

      Hive Workshop NUON Dome World Editor Tutorials

      Network Sponsors

      Apex Steel Pipe - Buys and sells Steel Pipe.
      Top