Re: How To Delete Multiple Items Of Multiple Tables Using PHP and MySQL

From experience, I don't think you can run more then one SQL statement at once in a single time. Try assigning each variable with delete, then query them all seperately. I also don't think you need the ; in the SQL statement... ----- Original Message ----- From: "@ Nilaab" <superbus22@attbi.com> To: "Php-General" <php-general@lists.php.net> Sent: Tuesday, December 31, 2002 1:36 PM Subject: [PHP] How To Delete Multiple Items Of Multiple Tables Using PHP and MySQL : Hello Everyone, : : I want to DELETE multiple items of multiple TABLES in a MySQL database. My : version of MySQL is 3.23, which means this version doesn't support the : DELETE functionality on multiple tables. The following is my PHP code, where : $item_id is a multi-dimensional array containing the ids of the items I want : to delete from the table. : : # DELETE records : for ($i = 0; $i < count($item_id); $i++) { : $query_item2 .= "DELETE QUICK FROM item_dimension WHERE item_id = : '".$item_id[$i][0]."'; "; : $query_item2 .= "DELETE QUICK FROM item_popup WHERE item_id = : '".$item_id[$i][0]."'; "; : } : : When I run this through the database using PHP, it returns a syntax error in : the SQL. So what I did was echo out $query_item2, then copied and pasted the : SQL into the MySQL application manually, and ran it through. Well the exact : same SQL statement that I used in PHP worked when I entered it manually in : MySQL. In other words it didn't work doing it through PHP, but it worked in : MySQL directly. What gives? Is there a better way to delete multiple items : from multiple tables with one SQL string? I don't want to separate the two : DELETE functions and run them through two separate times because of overhead : concerns. I tried looking on the MySQL and PHP website for better ways of : using DELETE syntax on multiple tables, but I had no luck finding anything : useful with my version of MySQL. Any help would be greatly appreciated. : : : -- : PHP General Mailing List (http://www.php.net/) : To unsubscribe, visit: http://www.php.net/unsub.php : : :