Delete from multiple tables with php
| From: | Steve Bradwell | Date: | Tue, 09 Jul 2002 19:11:58 +0000 |
| Subject: | Delete from multiple tables with php | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-20430@lists.php.net to get a copy of this message | ||
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.