[PHP-DB] Delete from multiple tables with php

[Steve Bradwell]

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