ID: 10389
Updated by: sniper
Old-Status: Feedback
Status: Closed
Bug Type: MySQL related
Operating system: 
PHP Version: 4.0.4pl1
Assigned To: 

Can't reproduce. If still problem with latest CVS, reopen.


Previous Comments:

[2001-04-19 17:40:19] [EMAIL PROTECTED]
This appears to be related to 4.0.4pl1.  I can reproduce it on a 4.0.4pl1 box, but not 
anything newer.

Can you try 4.0.5 or a CVS snapshot?



[2001-04-19 16:42:54] [EMAIL PROTECTED]
I checked what you said with mysqladmin and mysql.  The
database "ue" does exist, as does the table "jobsc."  Thanks
for saying something about the table being empty, as it was.
I fixed this problem (I'd had it before, but i just did this new
script by itself to make sure) and added 1 entry to the table "jobsc."  PHP4 still 
returns the same warning as before on the
"SELECT * FROM jobsc"  and in the mysql console, executing
that instruction returns the one and only row in the table jobsc.


[2001-04-18 20:29:19] [EMAIL PROTECTED]
My would not return false.  It's been a long long day.

But it would return false if the table jobsc did not exist or the database ue did not 



[2001-04-18 20:26:15] [EMAIL PROTECTED]
Your query is not returning any rows, and as such mysql_query returns false.  False of 
course is not a valid mysql result and thus the "Warning".

If you are 100% certain the query returns results then that would be a problem, 
otherwise this is not a bug.

Please check this query from the mysql command line and reopen if there really is a 



[2001-04-18 19:45:58] [EMAIL PROTECTED]
Here is the code I am using that produces the error:

    $db = mysql_connect("localhost");
    mysql_select_db("ue", $db);
    $result = mysql_query("SELECT * FROM jobsc");
    $rows = mysql_num_rows($result);

on the last line is where the error is generated.  In
any browser, I see:

Warning: Supplied argument is not a valid MySQL result
resource ...

My setup contains apache 1.3.19 with the static PHP 4.0.4pl1
module compiled in.  My configure lines for PHP are:

./configure --with-apache=/home/apache_1.3.19

/usr/local/mysql is the install directory for mysql

That is all the information I believe I have, and I'm
relatively sure that PHP is not crashing, per say.


The remainder of the comments for this report are too long.  To view the rest of the 
comments, please view the bug report online.

ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at

PHP Development Mailing List <>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to