Re: PHP 4.0 Bug #5678 Updated: mysql_num_rows fails sometimes

Hola Bug, Thursday, July 20, 2000, 4:04:09 PM, escribistes: BD> ID: 5678 BD> Updated by: mrobinso BD> Reported By: coolio@mdq.com BD> Status: Feedback BD> Bug Type: MySQL related BD> Assigned To: BD> Comments: BD> Please provide the ./configure line used to compile BD> php, and the shortest possible snippet of code that BD> reproduces the problem. the ./configure line that I use was just that "./configure" because I just wan´t to compile it as a CGI... mysql support gets compiled by default... I resolved my problem compiling PHP 3.0.16 and everything works fine now... maybe the problem was that I compiled it without tell PHP where MY mysql where? When I compiled PHP 3.0.16 I specify the --with-mysql= and it works fine... the code that I used was: $select_notas = mysql_query("SELECT titulo,intro,id FROM espectaculos WHERE fecha_dia='$hoy' ORDER BY id DESC"); $cantidad = mysql_num_rows($select_notas); It works sometimes... It fails sometimes... With PHP 3.0.16 it works always... The error I get is like if the query doesn´t work... but it should... thanks -- bye!, coolio coolio@mdq.com