#19403 [Bgs]: Query unexpected error - Not a valid resutl...

ID: 19403 User updated by: jackrap@tin.it Reported By: jackrap@tin.it Status: Bogus Bug Type: MySQL related Operating System: Windows XP PHP Version: 4.2.3 New Comment: Problem resolved! The problem wasn't MySQL but null value of variables passed by URL.....and now it is a new problem ;-) Previous Comments: ------------------------------------------------------------------------ [2002-09-14 15:23:25] georg@php.net Currently, we have 3.23.x in the 3-tree, 3.32 is science fiction! Please provide enough information for this possible error: "Enough information" includes: a) a "create table statement or a describe table output b) mysql_errno return codes after mysql_query ------------------------------------------------------------------------ [2002-09-14 13:08:00] derick@php.net What does "echo mysql_error();" show if you execute it just after the mysql_query() call? Derick ------------------------------------------------------------------------ [2002-09-14 11:56:27] jackrap@tin.it ...in particular this code generates error : mysql_fetch_row($result); and mysql_num_rows($result); ------------------------------------------------------------------------ [2002-09-14 11:24:17] jackrap@tin.it I explain another time my problem: i'm using php 4.2.3 with mysql 3.32.28 my PHP CODE: $sql = "SELECT * FROM mytable"; $result = mysql_query($sql,$connection); and PHP output is: Warning: Supplied argument is not a valid MySQL result resource in c:\myfile.php on line 5 With PHP 4.1.3 this error doesn't occur, using the same PHP code ------------------------------------------------------------------------ [2002-09-14 09:16:17] derick@php.net Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.php.net/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to "Open". Thank you for your interest in PHP. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/19403 -- Edit this bug report at http://bugs.php.net/?id=19403&edit=1