Merlin wrote:
I would like to delete a row inside a mysql table. To find out which
rows are affected the system has to check another table.
Somehow I am doing this statement wrong and I cant find out why. Does
anybody see the error?
Thanx for any help on that.
DELETE
FROM $table1 pi
RIGHT
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
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
()
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