[PHP] Re: mysql_num_rows error

2002-10-08 Thread Jonathan Duncan 

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

2002-10-08 Thread David Robley 

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