Delete using foreach

macca_25

Hi all,
I can't seem to get this working:

$delete_specs = mysql_query("SELECT order_specs.order_spec_id FROM orders,order_specs WHERE orders.order_id=order_specs.order_id AND orders.order_number_id='" . $_GET["order_number_id"] . "'");
while($row = mysql_fetch_array($delete_specs)){
foreach ($row['order_spec_id'] as $del) {
$delete = mysql_query("DELETE FROM order_specs WHERE order_spec_id='$del'");
}
}

I'm getting the following errors:
Warning: Invalid argument supplied for foreach() in /home/oxidenet/public_html/admin/inc/incorders.php on line 15

Warning: Invalid argument supplied for foreach() in /home/oxidenet/public_html/admin/inc/incorders.php on line 15

Any ideas on how to get this working?
Cheers,
macca

TheDefender

You should try just echoing your variable out before you run the foreach... The SQL statement doesn't look rright.

Try:

$delete_specs = mysql_query("SELECT order_spec_id FROM orders,order_specs WHERE orders.order_id=order_specs.order_id AND orders.order_number_id='" . $_GET["order_number_id"] . "'");

since the fiel name is the same for both tables. I believe the way you had it before was forcing it to try to fine a field named orders.order_spec_id from both tables... Not 100% on the syntax here. I am on the road today and don't have my computer to test with, but hope this helps anyways.

ppowell

DId you check to see if $row is a valid array generated by mysql_fetch_array()? If not, that is why foreach() is failing; it is trying to parse a non-array.

Do this:

print_r($row);

and see your contents to check if $row returned anything.

Phil