Re: [PHP-DB] Delete from multiple tables with php

2002-07-09 Thread Miles Thompson
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

[PHP-DB] Delete from multiple tables with php

2002-07-09 Thread 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.