#19403 [Bgs]: Query unexpected error - Not a valid resutl...
| From: | georg@php.net | Date: | Sat, 14 Sep 2002 20:23:26 +0000 |
| Subject: | #19403 [Bgs]: Query unexpected error - Not a valid resutl... | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-19362@lists.php.net to get a copy of this message | ||
ID: 19403
Updated by: georg@php.net
Reported By: jackrap@tin.it
Status: Bogus
Bug Type: MySQL related
Operating System: Windows XP
PHP Version: 4.2.3
New Comment:
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
Previous Comments:
------------------------------------------------------------------------
[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.
------------------------------------------------------------------------
[2002-09-14 08:20:30] jackrap@tin.it
I've installed MySQL 3.23.28 and PHP 4.2.3.
After execution of a Query PHP says : "Mysql...is not a valid
result..."
Latest version I used of PHP is 4.1.3 and this error doesn't occur.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=19403&edit=1