RE: [PHP] mysql_num_rows() error
| From: | Jay \(PHP List\) | Date: | Fri, 10 Jan 2003 03:25:23 +0000 |
| Subject: | RE: [PHP] mysql_num_rows() error | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-131028@lists.php.net to get a copy of this message | ||
You query is incorrect. Try doing the same query from the MySQL clent.
|-> -----Original Message-----
|-> From: Phil Powell [mailto:soazine@erols.com]
|-> Sent: Thursday, January 09, 2003 7:46 PM
|-> To: php-general@lists.php.net; talk@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
|->
|->