Trying to count an array

[bdl]

I'm trying to count an array with the values output from mysql_affected_rows. The rows are deleted properly, but it returns '1' no matter how many rows are selected and deleted. Ideas?

PHP Code:

foreach ($del_row as $row_id) {
             $result = mysql_query("DELETE FROM $db_table WHERE id = $row_id");
        }
        $deleted_rows = array(mysql_affected_rows());
        $num_rows = count($deleted_rows);
        echo $num_rows . " deleted.\n<br><br>\n"; 


[sde]

mysql_affected_rows() returns the total rows affected by '1' query. therefor, since you are doing a 'foreach' loop, your last query affected 1 row.

in your case, you are running a query that will affect 1 row no matter what.

this code will get you the total deleted rows:

PHP Code:

<?
$i;
foreach ($del_row as $row_id) {
             $result = mysql_query("DELETE FROM $db_table WHERE id = $row_id");
     $i++;
        }
      
        echo $i. " deleted.\n<br><br>\n";
?>

now here's an example where mysql_affected_rows might work better.

PHP Code:

<?
// lets say $some_var appears in the field for 20 rows
$result=mysql_query("delete  from table where field='$some_var'");
$deleted_rows=mysql_affected_rows();

echo $deleted_rows . " deleted.\n<br><br>\n";
?>

that's a cool function.. i didn't know about it till now =)

[bdl]

Thanks for the reply; didn't consider just using an incremented variable like that, good call, works perfectly. Using that particular function doesn't seem to work the way I want it to in this case but, mysql_affected_rows is a very cool little trick, I've used it several times. =)

[Admin]

you can add things like count(XXX) into your query as well when doing a select.

where XXX is some column you want to count.