I am trying to make a HTML anchor search for all the records with a few keywords found in a particular field.
For example, there is a database field called Fieldname which people would insert the name of the field they play on. I have a HTML page that has a link that says "View tournaments by field..click on the field name" So when they click on the name of the field it will pull up all the tournaments that field has posted.
Up until now I've used one keyword which is fine. However, I am running into some problems because some of the fields have a couple words that are the same. That doesn't seem like it's a problem, but I can't figure out how to search for a couple keywords. For some reason it will only pull up records if you search for one keyword, but if you try to do more than one, it will only pull it up if you have the exact words in the field.
Richard
For example, there is a database field called Fieldname which people would insert the name of the field they play on. I have a HTML page that has a link that says "View tournaments by field..click on the field name" So when they click on the name of the field it will pull up all the tournaments that field has posted.
Up until now I've used one keyword which is fine. However, I am running into some problems because some of the fields have a couple words that are the same. That doesn't seem like it's a problem, but I can't figure out how to search for a couple keywords. For some reason it will only pull up records if you search for one keyword, but if you try to do more than one, it will only pull it up if you have the exact words in the field.
Richard