shop by price

[ianhaney]

Hello
On my website, I would like to have a shop by price, something like the following

£0.01 - £2.99
£2.99 - £3.99
£3.99 - 6.99
£6.99 - £9.99
£9.99 or more

How would I do that and get the results from the mysql database when click on one of the above price links

[kyle04]

You could have each price "link" as a form :

<form name="prices_1" action="yourpage.php" method=POST>
<input type=hidden name="start_price" value="0.01">
<input type=hidden name="end_price" value="2.99">
input type=submit value="£0.01 - £2.99" name="price_range">
</form>

yourpage.php :

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

$start = $_POST['start_price'];
$end = $_POST['end_price'];

$result = mysql_query("SELECT*FROM TABLENAME WHERE FIELD_PRICE BETWEEN $start AND $end");
while($row = mysql_fetch_array($result)) {

$price = $row['FIELD_PRICE'];
// etc
}
} // isset

Or the price links as request urls :
yourpage.php?start=001&end=2.99
Then just use the mysql query :
$result = mysql_query("SELECT*FROM TABLENAME WHERE FIELD_PRICE BETWEEN $start AND $end");

AndyP