Re: delte stmt problem with joins
| From: | John W. Holmes | Date: | Fri, 29 Aug 2003 13:55:04 +0000 |
| Subject: | Re: delte stmt problem with joins | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-30229@lists.php.net to get a copy of this message | ||
Merlin wrote:
Hi John, I am using MySQL 3.x My guess is that it does not support a query like this. If so, I am sure that there is a workaround I just dont know about. The values $tablex are present. This is the error msg: Error: 1064 You have an error in your SQL syntax near 'pi INNER JOIN table2 AS p ON p.ID = pi.product_id WHERE p.ow' at line 3There is no work around. You must first select the numbers you want to match, store them in PHP, then issue a delete query using those numbers from php. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals – www.phparch.com