note 9212 deleted from mysql_num_rows by ronabop
| From: | ronabop@php.net | Date: | Thu, 02 Nov 2000 06:34:03 +0000 |
| Subject: | note 9212 deleted from mysql_num_rows by ronabop | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-7261@lists.php.net to get a copy of this message | ||
For those of you who are like me you might forget to select the database. Took me a half an hour
just to figure that out so here is an example of what I've come up with.
-- IE: If you wanted total members of a message board --
$conn = mysql_connect("hostaddress", "username", "password");
mysql_select_db("database",$conn);
$Resultfornummembers = mysql_query("SELECT * FROM Accounts",$conn);
$NumMembers = mysql_numrows($Resultfornummembers);
echo "$NumMembers Members";