how do i order by price greater than 4000
$sql = "SELECT * FROM Listings WHERE type='$category' ORDER BY price (greater than) 4000" ?
cheers aron.
Why not just add a clause to only pull things with a price greater than 4000?