Posts by Lucas Abade • 31 points
1 post
-
3
votes3
answers271
viewsQ: How to optimize SQL queries containing SELECT-related DELETE?
$a = mysql_query("SELECT * FROM catalog_items where page_id='84'") or die(mysql_error()); while ($row = mysql_fetch_array($a)){ $base_item = $row['item_ids']; mysql_query("DELETE FROM items_rooms…