Re: counting records in db

["Dave Goodchild" <buddhamagnet@xxxxxxxxx>]

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