Searching Multiple fields in record
Posted: Thu Apr 03, 2003 5:28 pm
Help -
I'm looking for some code that will search multiple fields in one record. For example, I've got a database of people where there is a skill1, skill2, and skill3. Many people have the same skill, but not in the same field (some have the skill of "framing," for example, in the skill1 field, and others have it in the skill2 field, and so on). What I need is a script that queries the database and then displays the person and the skill that was searched for next to each person. What's happening is that it's returning the people correctly, but only displays the skill that's in the skill1 field. See the link below for an example and also for the code:
example of what's going on:
http://www.zeitco.com/skill.php
code is here:
http://www.zeitco.com/skillcode.htm
Thanks for the help
I'm looking for some code that will search multiple fields in one record. For example, I've got a database of people where there is a skill1, skill2, and skill3. Many people have the same skill, but not in the same field (some have the skill of "framing," for example, in the skill1 field, and others have it in the skill2 field, and so on). What I need is a script that queries the database and then displays the person and the skill that was searched for next to each person. What's happening is that it's returning the people correctly, but only displays the skill that's in the skill1 field. See the link below for an example and also for the code:
example of what's going on:
http://www.zeitco.com/skill.php
code is here:
http://www.zeitco.com/skillcode.htm
Thanks for the help