Sorry, my bad! It works jsut fine. I did misstake. :) >> >> >> > $query = mysql_query(" >> > SELECT COUNT(*) as NoOfRecords >> > FROM customers >> > WHERE last_name = 'Smith'"); >> > $result = mysql_result($query, 0); >> > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php