Bug #18010: mysql_query hangs when request to return multiple columns occours

From: dave_bachtel@yahoo.com Operating system: PHP=FreeBSD/Apache mySQL=WinXP PHP version: 4.2.1 PHP Bug Type: MySQL related Bug description: mysql_query hangs when request to return multiple columns occours Ok, this works: $result = mysql_query("select server from ftpsearch where fullurl like '$query'"); The following queries do not work: 1.) $result = mysql_query("select server, fullurl from ftpsearch where fullurl like '$query'"); 2.) $result = mysql_query("select * from ftpsearch where fullurl like '$query'"); Basically, any request asking for multiple columns to be return fails miserably. Both of these statements work fine when using the mysql.exe client, so I know they are syntactically correct. When two or more colums are requested, it hangs. Not even the html at the top of the page is displayed. The server running PHP is hosted remotely, I have no access to it. The server running mySQL is with me, so I can modify and change it if necessary. Thx, -dave- -- Edit bug report at http://bugs.php.net/?id=18010&edit=1 -- Fixed in CVS: http://bugs.php.net/fix.php?id=18010&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=18010&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=18010&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=18010&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=18010&r=support Expected behavior: http://bugs.php.net/fix.php?id=18010&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=18010&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=18010&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=18010&r=globals