[PHP-DB] MySQL: Problem optimizing multi-table row deletion ... errors out :(

2004-09-13 Thread -{ Rene Brehmer }-
hi gang I'm working on optimizing the SQL for my forum system, but have run into a problem trying to optimize the function for deleting a thread with accompanying stats data and posts from the database using 1 query. The current function, that works, looks like this: // delete all traces of a

Re: [PHP-DB] MySQL: Problem optimizing multi-table row deletion ... errors out :(

2004-09-13 Thread randy
If the threadID column is an int, you don't need to wrap the $threadID variable in quotes. HTH ~randy On Tue, 14 Sep 2004 00:05:56 +0200, -{ Rene Brehmer }- [EMAIL PROTECTED] wrote: hi gang I'm working on optimizing the SQL for my forum system, but have run into a problem trying to optimize