Bug #5678 Updated: mysql_num_rows fails sometimes

ID: 5678 Comment by: michaelkingswood@hotmail.com Old Reported By: coolio@mdq.com Reported By: michaelkingswood@hotmail.com Status: Closed Bug Type: MySQL related Operating System: Solaris 7 PHP Version: 4.0.1pl2 New Comment: I have the same problem, mysql_num_rows just doesnt work! it is saying that (line 8) $check1= mysql_query("select id from users where user='$user'") or die("Bad query1: ".mysql_error()); (line 9) $check1= mysql_num_rows($check1) or die("Bad query2: ".mysql_error()); when run it is coming up with: Bad query2: and thats it. COuld someone please get back to me on what the problem is and how i could fix it if i can, thanx Previous Comments: ------------------------------------------------------------------------ [2000-08-18 21:31:27] sniper@php.net No feedback and not enough info. (and works for me just fine with latest CVS) --Jani ------------------------------------------------------------------------ [2000-07-20 21:04:09] mrobinso@cvs.php.net Please provide the ./configure line used to compile php, and the shortest possible snippet of code that reproduces the problem. ------------------------------------------------------------------------ [2000-07-19 17:12:28] coolio@mdq.com I have PHP 4.0.1pl2 compiled as a CGI on my Solaris. I use MySQL 3.22.32 The script fails only sometimes. I run the script and works fine... 1 minute later, I run the script again and it fails... maybe later fails again.. or maybe not... It´s not a script problem... it seems like a PHP or MySQL problem... ------------------------------------------------------------------------ Edit this bug report at http://bugs.php.net/?id=5678&edit=1