AW: [PHP-DB] SQL Select statement

think you can give your problem another approach, splitting it in two queries and joining the result sets through php script. Sometimes you can't put SQL to do all the work. That's true, but in most cases it is more efficient to leave the joins, orders etc. in the DB, because its more optimzed

[PHP-DB] Links On The Fly

Hi All I have a search engine which generates a page full of links. Depending on the link that was clicked, I want to load info on the fly. How do I do that? Regards Sridhar Ranganathan _ Get Your Private, Free E-mail from

Re: [PHP-DB] SQL Select statement

Addressed to: "JJeffman" [EMAIL PROTECTED] "PHPDB" [EMAIL PROTECTED] "bill" [EMAIL PROTECTED] ** Reply to note from "JJeffman" [EMAIL PROTECTED] Sat, 17 Feb 2001 13:11:20 -0300 Try this way : "select t1.memberID,t1.choice,t2.memberID, t2.choice from table as t1,