Sort by lowest price in a Mysql table

Question

Navigation

#1 by (2 votes)

2

How to list products that have the lowest price for the largest!

From lowest to highest! Using PHP and Mysql.

php mysql

asked by anonymous 17.04.2015 / 22:36

1 answer

Problem in regular expression in .htaccess How to work with the @Html.DropDownList?

score 2 · Answer 1

Just add this code to the end of your select :

ORDER BY 'preco' Asc

In this case, you use ASC to sort ascending and DESC to sort descendingly.

A% complete% would look like this:

SELECT * FROM 'produtos' ORDER BY 'preco' Asc

You can see an example using select in this link.

Here's an example in SqlFiddle: Example here