Re: select/query from two tables

2004-10-08 Thread SGreen
You didn't try it, did you 8-). In a nutshell a basic SELECT statement looks like: SELECT /columns list/ FROM /tables list/ WHERE /conditions list/ The /columns list/ is where you specify all of the values you want from the database, including constant and computed values The /tables list/

Re: select/query from two tables

2004-10-08 Thread Michael Stassen
No. You only get one FROM clause, so it's "SELECT columns FROM tables...". See the manual for complete details of SELECT syntax . Michael leegold wrote: On Fri, 8 Oct 2004 12:22:37 -0400, [EMAIL PROTECTED] said: I think that this will work: $query =

Re: select/query from two tables

2004-10-08 Thread leegold
On Fri, 8 Oct 2004 12:22:37 -0400, [EMAIL PROTECTED] said: > I think that this will work: > > $query = "SELECT page.*, url.* FROM `page` LEFT JOIN `keywords` USING > (`page_id`) LEFT JOIN URL USING (`page_id`) WHERE MATCH > (`keywords`.`keyword_txt`) AGAINST ('$keyword' > IN BOOLEAN MODE)"; Sor

Re: select/query from two tables

2004-10-08 Thread SGreen
I think that this will work: $query = "SELECT page.*, url.* FROM `page` LEFT JOIN `keywords` USING (`page_id`) LEFT JOIN URL USING (`page_id`) WHERE MATCH (`keywords`.`keyword_txt`) AGAINST ('$keyword' IN BOOLEAN MODE)"; Shawn Green Database Administrator Unimin Corporation - Spruce Pine "lee