[PHP-DB] Re: JOIN in embedded query

2002-08-08 Thread David Robley
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... > "David Robley" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED]... > > In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > > says... > > > UPDATE Emails SET Sent = 'T' WHERE ID = (SELECT Emails.ID FROM Emails > RIGHT > > > J

Re: [PHP-DB] JOIN in embedded query

2002-08-08 Thread leo g. divinagracia iii
since you didnt list what type DB you are using, i assumed MYSQL. and MYSQL doesnt have sub SELECTs... :( http://www.mysql.com/doc/en/UPDATE.html the syntax lists "...WHERE where_condition..." Michael Hendsbee wrote: > UPDATE Emails SET Sent = 'T' WHERE ID = (SELECT Emails.ID FROM Emails

[PHP-DB] Re: sucking news out of the usenet

2002-08-08 Thread andy
sorry for posting into the wrong forum. My mistake! "Andy" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi guys, > > I am trying to build a usenet gateway which is collecting usenet posts and > puts them into a phpbb forum. Same other way around.

[PHP-DB] sucking news out of the usenet

2002-08-08 Thread andy
Hi guys, I am trying to build a usenet gateway which is collecting usenet posts and puts them into a phpbb forum. Same other way around. So I did read an excelent article on that published by Armel Fauveau at: http://www.phpbuilder.com/columns/armel20010427.php3?page=1 (this is where the code und