Thought I replied already to this but its not here so I will repost.
Thanks for the info. Will check it out.. Actually I would like to do it correctly. I have searched around and read a bunch and am getting more confused.
From what you are saying and what I am reading, I need a 3rd table, correct? mainID (the dr) and specialtyID(the specialty). Many to many relationship. Problem I will have is then I will have to change the back end to get them into the database correctly. How do I insert them into the db.
Then on the search end, will the WA extensions do that?
Hopefully this is the correct way to do it.. Would rather get it right from the beginning.
Thanks so much.
Added after trying above.. after adding the
29 $WADbSearch1->addComparisonFrom("specialtiesID","". $_GET["specialtiesID"]. ",","OR","Begins With",0);
30 $WADbSearch1->addComparisonFrom("specialtiesID",",". $_GET["specialtiesID"]. "","OR","Ends With",0);
31 $WADbSearch1->addComparisonFrom("specialtiesID",",". $_GET["specialtiesID"]. ",","OR","Includes",0);
32 $WADbSearch1->addComparisonFromEdit("specialtiesID","specialtiesID","OR","=",0);
I get this:
Fatal error: Call to undefined method FilterDef::addComparisonFrom() in public_html/mdb/results.php on line 29