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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php