Re: [PHP-DB] delte stmt problem with joins
by John W. Holmes other posts by this author
Aug 29 2003 1:55PM messages near this date
Re: [PHP-DB] delte stmt problem with joins
|
Re: [PHP-DB] Problem in executing linux command from PHP
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
Thread:
Merlin
John W. Holmes
Merlin
John W. Holmes
|
