Hello there
I have three tables:
table 1: interviewer -> used to store the name of interviewwr
Feilds:
interviewerID int autonumber
FullName text
table 2: show_interviewers -> used to keep track of interviers for shows since there can more then on interviewer
Feilds:
showID int
interviewerID int
table 3: has all of the show information
Feilds:
showID auto number
this is the format i was using for it full text search it works but takes for every
SELECT shows.show_number, shows.length, shows.summary, shows.recorded_date, MATCH (interviewers.FullName) AGAINST('" . $txtInterviewer . "') AS score from shows, show_interviewers, interviewers
WHERE MATCH (interviewers.FullName) AGAINST ('" . $txtInterviewer . "')
AND shows.tapeID = show_interviewers.showID
AND interviewers.interviewerID = show_interviewers.interviewerID";
any ideas
I have three tables:
table 1: interviewer -> used to store the name of interviewwr
Feilds:
interviewerID int autonumber
FullName text
table 2: show_interviewers -> used to keep track of interviers for shows since there can more then on interviewer
Feilds:
showID int
interviewerID int
table 3: has all of the show information
Feilds:
showID auto number
this is the format i was using for it full text search it works but takes for every
SELECT shows.show_number, shows.length, shows.summary, shows.recorded_date, MATCH (interviewers.FullName) AGAINST('" . $txtInterviewer . "') AS score from shows, show_interviewers, interviewers
WHERE MATCH (interviewers.FullName) AGAINST ('" . $txtInterviewer . "')
AND shows.tapeID = show_interviewers.showID
AND interviewers.interviewerID = show_interviewers.interviewerID";
any ideas