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 statemen
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.