Re: search query
| From: | David Robley | Date: | Thu, 16 Sep 2004 04:45:03 +0000 |
| Subject: | Re: search query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-36219@lists.php.net to get a copy of this message | ||
On Wed, 15 Sep 2004 23:30, Peppe wrote:
> Hi
> I have a option box with values
> <select name="prijsklasse" class="bodyzwart"
> id="prijsklasse">
> <option value="1" selected>Less than 150.000
> <option value="2">tot 175.000
> <option value="3">tot 200.000
> <option value="4">tot 250.000
> <option value="5">tot 300.000
> <option value="6">tot 350.000
> <option value="7">tot 400.000
> <option value="8">More than 400.000
> </select>
> I need help when the user chose option value 3 till 200.000 than the query
> should search between 175.000 and 200.000 how to achive this
> Regards
SELECT fields FROM table WHERE something BETWEEN 175.000 AND 200.000
More information at
http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html
or see the docs
for whatever other database you use.
--
David Robley
"What's the value of a dollar bill?" asked Tom noteworthily.