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 |-> |-> |-> > 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 |-> |->
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php