Re: Is it possible to do a full text match with joined tables.

Article View: adobe.golive.dynamic.content

Article #104

Back to adobe.golive.dynamic.content Previous Next

#104

From: Jeremy_M._Cox
Date: Thu, 29 Jul 2004 15:57

15 lines
1585 bytes

Jerry,
Thanks again for the response....

Could you give me a nudge in the right direction.

Option 1. According to the MySQL manual you can use nested select statements. Are you suggesting that I use those.

Option 2 According to your tutorial you use a custom function called $where. Can I make two where functions (ie $where_1 & $where_2) where $where_1= " WHERE MATCH (faculty_info.faculty_first, faculty_info.faculty_last) AGAINST ("'.$_POST['matchString'].'")";
and $where_2= "WHERE MATCH (comm_classes.cat_num, comm_classes.class_name, comm_classes.class_desc, comm_classes.prog_study) AGAIST ("'.$_POST['matchString'].'")";

Then put both in the CS Wrap?

Option 3 "Go away kid you make no sense," Jerry thinks to him self.

Thanks again...

Technical Details

Message-ID: <3bb53f82.1@webx.la2eafNXanI>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!proxad.net!fr.ip.ndsoftware.net!newsfeed.freenet.de!216.196.110.149.MISMATCH!border2.nntp.ams.giganews.com!nntp.giganews.com!npeer.de.kpn-eurorings.net!feed.news.schlund.de!schlund.de!newsfeed01.sul.t-online.de!t-online.de!webx

References: <3bb53f82.-1@webx.la2eafNXanI>

Show Full Headers

Complete Article Headers

X-Google-Thread: 11ffd2,5be81bf8a12d8df7
X-Google-Attributes: gid11ffd2,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: Jeremy_M._Cox@adobeforums.com
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!proxad.net!fr.ip.ndsoftware.net!newsfeed.freenet.de!216.196.110.149.MISMATCH!border2.nntp.ams.giganews.com!nntp.giganews.com!npeer.de.kpn-eurorings.net!feed.news.schlund.de!schlund.de!newsfeed01.sul.t-online.de!t-online.de!webx
Newsgroups: adobe.golive.dynamic.content
Subject: Re: Is it possible to do a full text match with joined tables.
Message-ID: <3bb53f82.1@webx.la2eafNXanI>
Date: Thu, 29 Jul 2004 08:57:08 -0700
References: <3bb53f82.-1@webx.la2eafNXanI>
Lines: 21
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit

Reply to Parent Message