[PHP] Re: mysql_num_rows error
Omar, I would first take the select statement and try running it in mysql to make sure it actually runs (substituting a valid value for the variable of course). Then if it has problems you can see what error messages mysql gives you. Good Luck, Jonathan Duncan "Omar Campos" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I have a file. I'll paste from line 32 to 34 > > . > $sql = "select USUARIO from docente where USUARIO = '$usuario'"; > $result = mysql_query($sql, $link); > if (mysql_num_rows($result) == 1) { // line 34 > > ?> > > I get the next warning: > Warning: mysql_num_rows(): supplied argument is not a valid MySQL result > resource in /home/olimpiad/public_html/base/alta1.php on line 34 > > I'm running the script on a linux server. > could someone help me. > Thank you. > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: mysql_num_rows error
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... > I have a file. I'll paste from line 32 to 34 > > . > $sql = "select USUARIO from docente where USUARIO = '$usuario'"; > $result = mysql_query($sql, $link); Replace the above line with (all on one line) $result = mysql_query($sql, $link) or die("Error: " . mysql_error()."Query: ".$sql); > if (mysql_num_rows($result) == 1) { // line 34 > > ?> > > I get the next warning: > Warning: mysql_num_rows(): supplied argument is not a valid MySQL result > resource in /home/olimpiad/public_html/base/alta1.php on line 34 > > I'm running the script on a linux server. > could someone help me. > Thank you. And when you get the error message, you will have the actual query to check. Cheers -- David Robley Temporary Kiwi! Quod subigo farinam -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php