Re: Delete from multiple tables with php
| From: | Miles Thompson | Date: | Tue, 09 Jul 2002 19:28:08 +0000 |
| Subject: | Re: Delete from multiple tables with php | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20431@lists.php.net to get a copy of this message | ||
I think this changed this in the more recent version(s) of MySQL. Check the MySQL docs which match your current version. Proceed from there, it's only a query.
Miles Thompson
At 03:11 PM 7/9/2002 -0400, Steve Bradwell wrote:
Hi,
What is the best way to simulate the following delete statement with php to
MySQL 3.23......?
$sql = "DELETE ordlines.*, ordmaster.* FROM ordlines, ordmaster";
$sql.= " WHERE ordlines.ORDER_NO ='".$order."'";
From what I've read MySQL doesn't support deletes from multiple tables.
TIA,
Steve.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php