getting number of rows deleted.?

i want after delete g开发者_开发百科etting number of rows deleted (How many of rows are deleted?). how is it?

In your PHP code, you can retrieve the number of rows that were deleted by calling the mysql_affected_rows() function and then return that value back to your Javascript.

Your PHP code might look similar to this:

...
$query = "DELETE FROM myTable WHERE some_column=something";
mysql_query($query);
$number_of_rows_deleted = mysql_affected_rows();
return $number_of_rows_deleted;
...

MAYBE you can count the checked checkboxes, on your JavaScript:

var total = $(':checkbox:checked', '.ser_form').size();
alert(total + ' rows deleted');

This way you're not counting the deleted rows from the database, only the count of checked checkboxes.