Gossamer Forum
Home : Products : DBMan SQL : Discussion :

How did you do it?

Quote Reply
How did you do it?
In the homes example on your site you have a drop down menu for price max and price min. What code do you need to have in the search form to make this work? Is there any special requirments you need to have in the add_form and table as well?

I would realy like to add this feature - any help?

Thanks
Quote Reply
Re: [needsupport] How did you do it? In reply to
Hi,

Basicly, you can use field-gt and field-lt for a range searching ...e.g. price-gt ("price" must be greater than a number) and price-lt(less than). You can also use ">100" or "<200" directly in field values.


Hope that helps,
jean(at)Gossamer-Threads.com


Quote Reply
Re: [jean] How did you do it? In reply to
How about if I want to be say greater than and equal and also less than and equal.

Eg,

Say we have price between $2 and $5. If I use the code you described will it include listings that have $2 and $5 or just between $2.10 to $4.90?