Código:
al ordenar by precio asc quedaria asi+------+-------------+------+ | id | precio | stock | +------+-------------+------+ | 1 | 10.35| 10 | | 2 | 25.48| 3| | 3 | 33.54| 21 | | 4 | 100.25| 26 | | 5 | 3.24| 0| | 6 | 67.50| 31 | +------+-------------+------+
Código:
al ordenar by stock asc quedaria asi+------+-------------+------+ | id | precio | stock | +------+-------------+------+ | 5 | 3.24| 0| | 1 | 10.35| 10 | | 2 | 25.48| 3| | 3 | 33.54| 21 | | 6 | 67.50| 31 | | 4 | 100.25| 26 | +------+-------------+------+
Código:
Lo que necesito es que se ordene asi, osea precio mas barato con stock+------+-------------+------+ | id | precio | stock | +------+-------------+------+ | 5 | 3.24| 0| | 2 | 25.48| 3| | 1 | 10.35| 10 | | 3 | 33.54| 21 | | 4 | 100.25| 26 | | 6 | 67.50| 31 | +------+-------------+------+
Código:
y no logro encontrar la forma, me echan una mano?? +------+-------------+------+ | id | precio | stock | +------+-------------+------+ | 1 | 10.35| 10 | | 2 | 25.48| 3| | 3 | 33.54| 21 | | 6 | 67.50| 31 | | 4 | 100.25| 26 | | 5 | 3.24| 0| +------+-------------+------+