counting number of records in a MySQL table; how do I get the result?

From: 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

« previous php.general (#118654) next »