affected_rows when deleting mulitple rows via checkbox

[bluns]

Hi guys, is there anyway around displaying the amount of records deleted when deleting data via checkboxes?

mysql_affected_rows(); always displays 0 no matter how many rows are deleted, even though they are indeed deleted.

processing.php

  mysql_select_db($db_name);
  $query = "delete from data where id=$id"; 
  $result = mysql_query($query); 
    if (!$result) 
   { 
    mysql_error();
	exit();      

   } 
   //Tell user how much data deleted
  if(mysql_affected_rows()>=1)
   {
      echo  mysql_affected_rows().' data successfully deleted from database.';
	  exit(); 

form.php

      <td><input type='checkbox' name='to_delete[]' value='$row[id]'></td>

[midget]

I think MySQL always returns 0 Rows affected even on console deletion...

Not sure about this... but I remember this case happened to me in previous MySQL versions...

The '0 rows affected' message can/could be found as well in GRANT statements even when it works (as I remember)

midget

[richie]

Is id a unique column? If so, only one row would be deleted.

In that case you should be checking if mysql_affected_rows == -1

When delete fails, -1 is returned.

See

php.net/mysql_affected_rows

Richie.

[tekky]

Your problem lies in not reading documentation....

mysql_affected_rows
(PHP 3, PHP 4 )

mysql_affected_rows -- Get number of affected rows in previous MySQL operation
Description
int mysql_affected_rows ( [resource link_identifier])

mysql_affected_rows() returns the number of rows affected by the last INSERT, UPDATE or DELETE query associated with link_identifier. If the link identifier isn't specified, the last link opened by mysql_connect() is assumed.

Note: If you are using transactions, you need to call mysql_affected_rows() after your INSERT, UPDATE, or DELETE query, not after the commit.

If the last query was a DELETE query with no WHERE clause, all of the records will have been deleted from the table but this function will return zero.

Note: When using UPDATE, MySQL will not update columns where the new value is the same as the old value. This creates the possibility that mysql_affected_rows() may not actually equal the number of rows matched, only the number of rows that were literally affected by the query.

mysql_affected_rows() does not work with SELECT statements; only on statements which modify records. To retrieve the number of rows returned by a SELECT, use mysql_num_rows().

If the last query failed, this function will return -1.

mysql_affected_rows() requires a resource_id IE: $result