Count deleted records

Hi,
Using MySQL
Is there an easy solution to count deleted records in a table?
For instance: I want to delete all records "Jones" in the table "names"
$query = "DELETE FROM names " ."WHERE host LIKE '$keyword[$i]'";
echo "$count records deleted";

Help much appreciated

On 1 Oct, 10:14, "H@C0" <n....TakeThisOut@fish.net> wrote:
> Hi,
> Using MySQL
> Is there an easy solution to count deleted records in a table?
> For instance: I want to delete all records "Jones" in the table "names"
> $query = "DELETE  FROM names " ."WHERE host LIKE '$keyword[$i]'";
> echo "$count records deleted";
>
> Help much appreciated

http://uk2.php.net/function.mysql-affected-rows