troubleshooting Question

Update & Delete from multiple tables in PHP?

Avatar of fcruz5
fcruz5Flag for United States of America asked on
PHP
2 Comments2 Solutions1731 ViewsLast Modified:
How do I update & delete from multiple tables in one query? What is the best way to do this?

Lets say I want to DELETE from table1, table2, table3, table4

and

UPDATE fields 1-5 on both table5 & table6
<?php
require('db.php');
 
mysql_query("DELETE FROM table1");
 
mysql_query("UPDATE table5 SET field1='', field2='', field3='', field4='', field5='' ");
 
mysql_close();
exit();
?>
ASKER CERTIFIED SOLUTION
Khanh Doan
Senior Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros