what php/mysql code do i need to dispaly
$sql = 'SELECT * FROM Rings ORDER BY Ring_Price LIMIT 0, 30';
$sql = 'SELECT * FROM Rings ORDER BY Ring_Price DESC LIMIT 0, 30';
i want to use the sort thing below to sort my products.
<form action="diamond.php" name="name" method="get">
<select name="Rings" id="">
<option value="lowToHigh">Low To High</option>
<option value="highToLow">High To Low</option>
</select>
Please Help!!!!!!!!!!!!!!!!!!!!!!!
<input type="submit" name="orderPrice" value="OrderPrice" />
</form>
$sql = 'SELECT * FROM Rings ORDER BY Ring_Price LIMIT 0, 30';
$sql = 'SELECT * FROM Rings ORDER BY Ring_Price DESC LIMIT 0, 30';
i want to use the sort thing below to sort my products.
<form action="diamond.php" name="name" method="get">
<select name="Rings" id="">
<option value="lowToHigh">Low To High</option>
<option value="highToLow">High To Low</option>
</select>
Please Help!!!!!!!!!!!!!!!!!!!!!!!
<input type="submit" name="orderPrice" value="OrderPrice" />
</form>