Re: counting number of records in a MySQL table; how do I get

Or another way if you don't want a result when it's zero. $rslt = mysql_query("SELECT count(*) as cnt FROM tbl having cnt > 0"); HTH.. Have a great day.. Dan Rasmus Lerdorf wrote:

$ret = mysql_query("SELECT count(*) as foo FROM AuthNum"); $result = mysql_fetch_array($ret); echo $result['foo']; One of many ways... -Rasmus On Wed, 2 Oct 2002, DonPro wrote:

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