> > 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
pi() is a mysql function that returns the value of pi. Could the pi in your query be causing some confusion? It seems that MySql may be expecting pi() not pi.productID. Just a guess since it's a syntax error. > -----Original Message----- > From: John W. Holmes [mailto:[EMAIL PROTECTED] > Sent: Friday, August 29, 2003 9:55 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] delte stmt problem with joins > > > 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: 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 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
