Re: [PHP] counting records in db

[Dave Goodchild]

$query = mysql_query("
              SELECT COUNT(*) as NoOfRecords
              FROM customers
              WHERE last_name = 'Smith'");
$result = mysql_result($query, 0);