Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [jamesamorris] How do I get exact Search Results

Quote Reply
Re: [jamesamorris] How do I get exact Search Results In reply to
When you set up the database, define the region column like this (for example):

Column Name:
REGION

Column Type:
ENUM

Column Values:
N
E
S
W
NE
NW
SE
SW

Form Names:
same as in Column Values

Form Values:
North
East
South
West
North East
North West
South East
South West


Assuming you don't use the default template, you could put this in your custom search_form.html:

<select name="REGION">
<option value="N">North</option>
<option value="S">South</option>
...
...
</select>
<input type="hidden" name="REGION-opt" value="=">


Or via direct URL (example for North East):
yourdomain.com/path/to/db.cgi?do=search_results&REGION=NE&REGION-opt==

Let me know if this helps.
Smileliver
Subject Author Views Date
Thread How do I get exact Search Results jamesamorris 4595 Aug 18, 2004, 5:51 AM
Thread Re: [jamesamorris] How do I get exact Search Results
olivers 4433 Aug 18, 2004, 8:57 AM
Thread Re: [olivers] How do I get exact Search Results
jamesamorris 4429 Aug 19, 2004, 3:30 AM
Post Re: [jamesamorris] How do I get exact Search Results
olivers 4420 Aug 19, 2004, 4:09 AM
Post Re: [jamesamorris] How do I get exact Search Results
604 4403 Aug 31, 2004, 12:18 PM