🚀 go-pugleaf

Jeremy

In reading the mysql manual, it doesn't appear to allow joins.

It looks like a multi-step process to me.

find the faculty ids using match.
then lookup the classes using where faculty_id in list of the first match set.

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...

I guess I am a little confused. I garnered from the example that you key words were the profs names. aka Joan, Atkins. I wasn't expecting them to be in the classes names or descriptions. It seems like you want to search on prof name and class description?

If all that is missing in the course table is the name of the prof, I would create a field like, scheduled prof and once assigned, populate it upon assignment.

Otherwise you do two searches and save the keys - courses and profs. then use the keys to add the two into one temp table.

The problem I see is applying the match against both parts of the relation while still trying to tie keys for course-prof also. You have a many to many relationship with a one to one mixed. Many to Many are those with key word matches, one to one are the course-prof combo.

Wow Jerry. Just wow. My head is spinning. I am gonna try to break down what you said. But in the mean time. Here is the function of the search.

A student would go to the current_classes page and search by instructor name to see what fall classes the instructor is teaching. Or maybe they just want to search for the classes by class name or catalog number to see what classes are being offered. And finally maybe they want to search for classes in a program of study for example Advertising. All this could be done if I use the search column by column but I don't get the advantages of full text search. If someone types in first and last name of an instructor it would return no results. Or if they type in class name and catalog number likewise.

I hope this makes sense. I just want to search this one table. Unfortunately it has joins and I must suffer for using relational capabilities. How often are tables not using joins. Seems like it would have these capabilities. Buy who am I? Thanks a lot, Jerry.

It looks like you want one text line to search all fields in multiple tables. Like we think, I do not beleive it possible in mySQL although posing it on their list might prove more worthy. It just seems to me that the way the fulltext index is setup it creates one file of the words and it can't deal with the file in the second table because it is a separate file. I think that's why all full-text indices must be made at the same time.

Since only prof names are in the one search I would have two areas, one for profs and one for course data. Perhaps a radio button to choose staff/courses near a single text area?

I might have just a list of profs. A click on one brings up the list of classes to make life even easier.

Jeremy,

Did you figure out a solution?
Was just wondering...

Jerry

Sorry Jerry,
I've been busy. I still have to post the question on the MySql website. But I will post it as soon as I find out or figure it out.... or if I figure it out.