#27727 [NEW]: mysql_query not returning the Resource ID

From: glmlc at hotmail dot com Operating system: Windows 2000 PHP version: 4.3.4 PHP Bug Type: MySQL related Bug description: mysql_query not returning the Resource ID Description: ------------ I used the MySql_Query with an argument put together as a string, part of it included the $_POST varible, and when passing the string to the MySql_Query I got no error, yet no resource id to use for the rest of my function. I have tried to force the stringtype to the varible and that still didn't work. Keep in mind that the info stored in the $_POST is selected from a table in the db called "books". Yet when I hard code the same format in the string it returns it. Only get the problem when I use the varible. Reproduce code: --------------- <?php if ($_POST != NULL) { echo "results for " . $_POST["Subject"]; $subject = $_POST["Subject"]; $qry = ("select * from " . $subject); $sqlQry = (string) $qry; GetVals(); } function GetVals() { $db = mysql_connect("localhost", "root"); mysql_select_db("books",$db); $result = mysql_query($sqlQry); echo $result; } ?> Expected result: ---------------- I expect it to echo the resource ID. This was a test code I developed while debugging the rest of the project. I leveled it down to this problem. It's not allowing me to use any of the rest of the mysql functions because the resource id is non-existant. I don't get errors until I try to use functions like MySql_fetch_row($result) and whatnot, and those errors say that the argument it invalid. Actual result: -------------- null is stored in $result, leaving me high and dry for the rest of the project. -- Edit bug report at http://bugs.php.net/?id=27727&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=27727&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=27727&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=27727&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=27727&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=27727&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=27727&r=needscript Try newer version: http://bugs.php.net/fix.php?id=27727&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=27727&r=support Expected behavior: http://bugs.php.net/fix.php?id=27727&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=27727&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=27727&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=27727&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=27727&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=27727&r=dst IIS Stability: http://bugs.php.net/fix.php?id=27727&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=27727&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=27727&r=float