Re: counting records in db

From: Date: Thu, 26 Oct 2006 17:39:55 +0000
Subject: Re: counting records in db
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-243687@lists.php.net to get a copy of this message
$query = mysql_query("
              SELECT COUNT(*) as NoOfRecords
              FROM customers
              WHERE last_name = 'Smith'");
$result = mysql_result($query, 0);

« previous php.general (#243687) next »