[djwayne_2004]

Hi Everyone,

I have a simple question for you all, would probably work it out for myself if i had the time . I have a very good knowledge of SQL so this should be easy for me but i have never come across using it before untill now... Basically i would like to specify some prices ranges in a drop down list which will be used to filter the returned data from mysql, i will have a column for price which the drop down list will search against. So i will need to query something like "BETWEEN 10.000 AND 20.000" but i'm not really sure on this one. I hope someone can help, i know this will be simple, i'll hit myself when i find out .

Thanks
Wayne

[dodod]

Code:

<form action="<?php echo basename($PHP_SELF); ?>" method="post">
<select name=lowestPrice><option value=5>$5.00</option></select> - 
<select name=highestPrice><option value=75>$75.00</option></select><br>
<input type=submit value=FILTER name=AgoGo>
</form>

PHP Code:

<?php

if(isset($_POST['AgoGo'])) {



$minimumPrice = $_POST['lowestPrice'];

$maximumPrice = $_POST['highestPrice'];

//Select the database, etc... These are 2 example queries.



$query_rs_Table = "SELECT * FROM table WHERE price > $minimumPrice AND < $maximumPrice"; 

$query2_rs_Table = "SELECT * FROM table WHERE price BETWEEN $minimumPrice AND $maximumPrice";



//Display the information

do { echo $row['price']; echo $row['name']; } while(XXXXXXXX);

} ?>

[djwayne_2004]

Hi dodod,

I knew it was something really simple and yet i have used both SQL statements in similar cases. I'm sure this Thread will be helpful for some other people learning SQL.

Thanks again,
Wayne