RE: [PHP] mysql_num_rows() error

2003-01-09 Thread Jay \(PHP List\)
You query is incorrect. Try doing the same query from the MySQL clent. |- -Original Message- |- From: Phil Powell [mailto:[EMAIL PROTECTED]] |- Sent: Thursday, January 09, 2003 7:46 PM |- To: [EMAIL PROTECTED]; [EMAIL PROTECTED] |- Subject: [PHP] mysql_num_rows() error |- |- |-

RE: [PHP] mysql_num_rows() error

2003-01-09 Thread Sean Malloy
Are you actually checking that the query result is valid? $conn = mysql_connect('localhost', xxx, yyy) or die('Could not connect to db'); $result = mysql_query('select * from blah', $conn); if ($result) { echo Number of rows: . mysql_num_rows($result); if (mysql_num_rows($result) 0) {

RE: [PHP] mysql_num_rows() error

2003-01-09 Thread Mark Charette
And which database are you using?? (hint - mysql_select_db() might be a good idea ...) -Original Message- From: Phil Powell [mailto:[EMAIL PROTECTED]] Anyone know why this is happening? I have mySQL on Win2000 Server with IIS and PHP: -- PHP General Mailing List

Re: [PHP] mysql_num_rows error

2002-10-08 Thread Stuart Dallas
Omar Campos wrote: 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 This usually means that the SQL query failed. You can check the value returned by mysql_query to see if this is

Re: [PHP] mysql_num_rows error

2002-10-08 Thread Wilmar Perez
Well, those error normaly appear when you've got something wrong in your sql statement. Make sure there is some information stored in your database, empty tables are sometimes troublesome. What do you use $link for? $sql = select USUARIO from docente where USUARIO = '$usuario'; $result =

RE: [PHP] mysql_num_rows error

2002-09-23 Thread John Holmes
I am new to php and that the folowing error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/tbonestu/public_html/smallimages.php i dont know what i am doing wrong here is the code: $db = mysql_pconnect(connect info);

RE: [PHP] mysql_num_rows error

2002-09-23 Thread M . A . Bond
I am new to php and that the folowing error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/tbonestu/public_html/smallimages.php i dont know what i am doing wrong here is the code: $db = mysql_pconnect(connect info);

RE: [PHP] mysql_num_rows error

2002-09-23 Thread Jon Haworth
Hi Nick, I am new to php and that the folowing error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/tbonestu/public_html/smallimages.php i dont know what i am doing wrong here is the code: $db = mysql_pconnect(connect info); Along with

Re: [PHP] mysql_num_rows error

2002-09-22 Thread Tom Rogers
Hi, Sunday, September 23, 2001, 3:25:02 PM, you wrote: NV I am new to php and that the folowing error: Warning: mysql_num_rows(): NV supplied argument is not a valid MySQL result resource in NV /home/tbonestu/public_html/smallimages.php NV i dont know what i am doing wrong here is the code: NV