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 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:

php|architect: The Magazine for PHP Professionals –

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to