counting number of records in a MySQL table; how do I get the result?
| From: | DonPro | Date: | Wed, 02 Oct 2002 20:35:33 +0000 |
| Subject: | counting number of records in a MySQL table; how do I get the result? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-118654@lists.php.net to get a copy of this message | ||
Hi,
I need to do either an insert or update into a MySQL table. Insert if there
are 0 records or update if one record exist:
This is my code snippet:
if (mysql_query("SELECT COUNT(*) FROM AuthNum") == 0) {
mysql_query("INSERT into AuthNum (FirstNum, LastNum, NextNum) VALUES
(1,2,3)",$dblink);
} else {
mysql_query("Update AuthNum Set FirstNum = 1, LastNum = 2, NextNum =
3",$dbLink);
}
My problem is, a record never gets inserted because the SELECT COUNT query
is returning a resource ID of 2. How can I get the actual number of records
in the table?
Thanks,
Don