以下是我的测试代码:$host="localhost";
$user="root";
$pwd="";
$con=mysql_connect($host,$user,$pwd,0,100000) or die("Not found");
mysql_select_db("zencart"); $procedure="call test()";
$query=mysql_query($procedure,$con);
$result=mysql_fetch_array($query,1);
print_r($result); //这行代码可以打印出来
mysql_free_result($query);
echo"<br><br><br><br>";
$procedure="call test()";
$query=mysql_query($procedure,$con);
$result=mysql_fetch_array($query,1); /*这行代码报错 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\1602\APMServ5.2.6\www\htdocs\demo2\procedure\index.php on line 17
*/
print_r($result);
mysql_free_result($query);
echo"<br><br><br><br>";
mysql_close($con);$con=mysql_connect($host,$user,$pwd,0,100000) or die("Not found");
mysql_select_db("zencart");
$mysql=mysql_query("call tests();",$con);
$result=mysql_fetch_array($mysql,1);
print_r($result); //这行代码又可以打印出来
请问下有实践过的朋友,指点一二。
$user="root";
$pwd="";
$con=mysql_connect($host,$user,$pwd,0,100000) or die("Not found");
mysql_select_db("zencart"); $procedure="call test()";
$query=mysql_query($procedure,$con);
$result=mysql_fetch_array($query,1);
print_r($result); //这行代码可以打印出来
mysql_free_result($query);
echo"<br><br><br><br>";
$procedure="call test()";
$query=mysql_query($procedure,$con);
$result=mysql_fetch_array($query,1); /*这行代码报错 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\1602\APMServ5.2.6\www\htdocs\demo2\procedure\index.php on line 17
*/
print_r($result);
mysql_free_result($query);
echo"<br><br><br><br>";
mysql_close($con);$con=mysql_connect($host,$user,$pwd,0,100000) or die("Not found");
mysql_select_db("zencart");
$mysql=mysql_query("call tests();",$con);
$result=mysql_fetch_array($mysql,1);
print_r($result); //这行代码又可以打印出来
请问下有实践过的朋友,指点一二。
你打印下$con,看看第二次的资源号还在不
这个呢??
$result=mysql_fetch_array($query,1); /*这行代码报错 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\1602\APMServ5.2.6\www\htdocs\demo2\procedure\index.php on line 17
*/
改变变量名称试试...