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