Running PHP v5.0.4 (compiled by
www.entropy.ch) and mysql 5.0.16 on Mac
OS X 10.4.3. When I run the simple test script below the first query
sent from PHP to MySQL is successful but the second is not. sp_select is a
simple one-line script that performs "select * from test". If I replace
the call to the stored procedure with a select that does the same thing,
both queries work and return results. Is this a PHP or MySQL problem?
<html><body><pre><?php$query = "CALL sp_select()";//$query =
"select * from test"; $link = mysqli_connect("localhost", "root",
"xxxxx","test");var_dump($link);$result = mysqli_query($link,
$query);var_dump($result);$row =
mysqli_fetch_row($result);var_dump($row);mysqli_fr ee_result($result);var_dump($link);$result = mysqli_query($link,
$query);var_dump($result);$row
=
mysqli_fetch_row($result);var_dump($row);mysqli_fr ee_result($result);mysqli_close($link);?></pre></body></html>
------------------------------
Results when $query = "CALL sp_select()"; are below:
object(mysqli)#1 (0) {
}
object(mysqli_result)#2 (0) {
}
array(2) {
[0]=>
string(1) "1"
[1]=>
string(4) "greg"
}
object(mysqli)#1 (0) {
}
bool(false)
Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result,
boolean given in /Library/WebServer/Documents/sp/test.php on line 21
NULL
Warning: mysqli_free_result() expects parameter 1 to be mysqli_result,
boolean given in /Library/WebServer/Documents/sp/test.php on line 23
------------------------------
Results when $query = "select * from test"; are below:
object(mysqli)#1 (0) {
}
object(mysqli_result)#2 (0) {
}
array(2) {
[0]=>
string(1) "1"
[1]=>
string(4) "greg"
}
object(mysqli)#1 (0) {
}
object(mysqli_result)#3 (0) {
}
array(2) {
[0]=>
string(1) "1"
[1]=>
string(4) "greg"
}
