ORDER BY (row) DESC

Question

I want to order the "rank" but it doesnt work, I tried many things but i cant find a solution to this.

$query = $handler->query("SELECT * FROM login ORDER BY rank DESC WHERE rank > 4 AND rank < 7 LIMIT 10");

Things I have tried:

I have no idea how to fix this since the webpage does not even load upon requesting it.

`select ... where ... order`. if you had error handling on your query call, you'd have been told about the syntax error. — Marc B, Oct 05 '15 at 15:00
Yes, your next task (both: learning and implementing) really should be error handling. Or else you will waste your time with wild guessing which is almost certain to lead to superstition and voodoo ;-) — VolkerK, Oct 05 '15 at 15:03
As an aside, you'll also need to prevent [sql injection](http://stackoverflow.com/questions/60174/how-can-i-prevent-sql-injection-in-php) in your queries. That doesn't strictly apply to the example in this question, but it's always a concern :) — Brian, Oct 05 '15 at 15:16

score 4 · Accepted Answer · answered Oct 05 '15 at 15:00

4

Order by should be after where clause

$query = $handler->query("SELECT * FROM login WHERE rank > 4 AND rank < 7 ORDER BY rank DESC LIMIT 10");

answered Oct 05 '15 at 15:00

Niranjan N Raju

score 0 · Answer 2 · answered Oct 05 '15 at 14:59

0

Try like this

$query = $handler->query("SELECT * FROM login WHERE rank > 4 AND rank < 7 ORDER BY rank DESC LIMIT 10")

answered Oct 05 '15 at 14:59

Arun Krish

I have added my answer 9 secs ahead of that accepted answer. Do I need to delete this? – Arun Krish Oct 06 '15 at 07:19

2 Answers2