php List Order Help

[dangelo]

I'm kind of new to php and I've been asked to make a change a website. One thing is to change the listing order of properties for high price to low. Currently, it is low to high. Here is the link to the page:

http://www.dangelorealty.com/listings.php

Could anyone provide me with some pointers?

Thank you

[djjjozsi]

you should add an order property listbox to the form.

and where you add the conditions together you can apply
an order BY sql statement.

[dangelo]

would it be simpler to make a small change to the code already existing?

[cahva]

Without seeing the code I cannot tell you exactly what to do, but search for the sql query which would be something like this:

SELECT * FROM listings 
ORDER BY price 
LIMIT 1,10

As djjjozsi said, you will use ORDER BY to set by which field you want to sort. Add ASC or DESC to the end of ORDER BY [fieldname] to set if its ascending or descending. In this case it would be descending so:

SELECT * FROM listings  

ORDER BY price DESC 
LIMIT 1,10

[dangelo]

That did it! Thank you all so much!