PHP Order By not working

Question

Here is my PHP Query, but it doesn't seem to order the results. Everything else works fine.

SELECT *  
FROM   `main` 
WHERE  `user_legacy` LIKE '%".$name."%' 
ORDER BY 'user_legacy' DESC LIMIT ".$limit

GordonM · Accepted Answer · 2012-02-19 08:44:10Z

3

You use backticks (') to quote column names in SQL, not the normal single quote (').

ORDER BY `user_legacy` DESC

Also, if you don't do any kind of vetting or your input, that query is potentially vulnerable to an SQL injection.

answered Feb 19, 2012 at 8:44

GordonM

31.9k17 gold badges94 silver badges134 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

I do strip the inputs, so there is no sql injection possibility. thanks for the detailed answer.

xdazz · Accepted Answer · 2012-02-19 08:43:44Z

3

Don't quote the column name.

ORDER BY user_legacy

answered Feb 19, 2012 at 8:43

xdazz

161k38 gold badges255 silver badges278 bronze badges

alexis · Accepted Answer · 2012-02-19 08:44:22Z

3

ORDER BY needs a column name, you're passing it a string. Lose the quotes.

answered Feb 19, 2012 at 8:44

alexis

50.4k18 gold badges108 silver badges173 bronze badges