NYCPHP Meetup

[Jay \(PHP List\)]

You query is incorrect.  Try doing the same query from the MySQL clent.

|-> -----Original Message-----
|-> From: Phil Powell [mailto:soazine at erols.com] 
|-> Sent: Thursday, January 09, 2003 7:46 PM
|-> To: php-general at lists.php.net; talk at nyphp.org
|-> Subject: [PHP] mysql_num_rows() error
|-> 
|-> 
|-> > Anyone know why this is happening? I have mySQL on 
|-> Win2000 Server with 
|-> > IIS and PHP:
|-> >
|-> > mysql_num_rows(): supplied argument is not a valid MySQL result 
|-> > resource
|-> >
|-> > Here is my code:
|-> >
|-> > <?
|-> >   $conn = mysql_connect('localhost', "xxx", "yyy") or 
|-> die('Could not
|-> connect
|-> > to db');
|-> >   $result = mysql_query('select * from blah');
|-> >   echo "Number of rows: " . mysql_num_rows($result);
|-> >   if (mysql_num_rows($result) > 0) {
|-> >    while ($row = mysql_fetch_row($result)) {
|-> >     for ($i = 0; $i < sizeOf($row); $i++) {
|-> >      echo "$i: " . $row[$i] . "<BR>";
|-> >     }
|-> >    }
|-> >   }
|-> > ?>
|-> >
|-> > It couldn't get any simpler.  I just installed mySQL on 
|-> my machine and 
|-> > am trying to see what I can do with it giving Win2K and IIS.
|-> >
|-> > AUGH! Thanx
|-> > Phil
|-> >
|-> 
|-> 
|-> -- 
|-> PHP General Mailing List (http://www.php.net/)
|-> To unsubscribe, visit: http://www.php.net/unsub.php
|-> 
|->