|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2004-01-05 18:22 UTC] iliaa@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sat Nov 22 04:00:01 2025 UTC |
Description: ------------ It looks like php5 doesn't yet support stored procedures which appeared in mysql5. Please see the code below (from the PHP Manual) If I uncomment line 4 and comment line 5 everything works OK. If the code works as provided and I try to call a stored procedure "yyy" (which includes a simple select statement) I have the following error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\Inetpub\wwwroot\index.php on line 9 Reproduce code: --------------- <? $link = mysql_connect("localhost", "root", ""); mysql_select_db("mysql"); //$query = "select * from user"; $query = "call yyy()"; $result = mysql_query($query); echo "<table>\n"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "\t<tr>\n"; foreach ($line as $col_value) { echo "\t\t<td>$col_value</td>\n"; } echo "\t</tr>\n"; } echo "</table>\n"; ?> Expected result: ---------------- I expect to see the results of calling a stored procedure (which executes a select statement)