ID: 41303 User updated by: admin at shadyindustries dot biz Reported By: admin at shadyindustries dot biz Status: Bogus Bug Type: MySQL related Operating System: Windows XP and Unix PHP Version: 4.4.7 New Comment:
yes, you were right, it should be print_r, however, that does not fix the actual problem. the While statement causes a server malfunction. Previous Comments: ------------------------------------------------------------------------ [2007-05-07 03:07:15] [EMAIL PROTECTED] . ------------------------------------------------------------------------ [2007-05-07 01:50:41] dayseye at 21cn dot com should print() be print_r() ? ------------------------------------------------------------------------ [2007-05-06 12:25:47] admin at shadyindustries dot biz Description: ------------ mysql_fetch_array and mysql_fetch_assoc return empty arrays when, for the same query, mysql_num_rows returns 5 - the correct number. also notable, the mysql_affected_rows causes a server malfunction for the same query. I have tested it both on my public webserver (unix, unknown webserver, PHP 4, MySQL 4) and my home computer (Windows XP, Apache2, PHP 5, MySQL 5), thus this problem would appear to not be related to just one circumstance. The really weird thing is that phpMyAdmin can read the database perfectly. Reproduce code: --------------- <?php $con = mysql_connect("####" ,"####" ,"####"); if (!$con) { trigger_error("Unable to connect to mysql, MYSQL ERROR: " . mysql_error(),E_USER_ERROR); } if (!mysql_select_db("NuevasIslas", $con)) { trigger_error("Unable to open database, MYSQL ERROR: " . mysql_error(),E_USER_ERROR); } while($row = mysql_fetch_array(mysql_query("SELECT * FROM `jaydev_config`"))) { $config[$row['name']] = $row['value']; } print "$config"; //print mysql_fetch_array(mysql_query("SELECT * FROM `jaydev_config`")); ?> Expected result: ---------------- Array ( [enabled_login] => 0 [enabled_register] => 1 [server_name] => JayDev [url_base] => http://ni.shadyindustries.biz/jaydev/ [url_forum] => http://forum.shadyindustries.biz/viewforum.php?f=4 ) Actual result: -------------- Array ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=41303&edit=1