PHP SQL Query ORDER by - Syntax-Mistake?

Question

I'd like to order the following query by id desc (it's a column in the "check_todo"-table). Can anybody help me? :)

$todo_query = mysqli_query($db, "SELECT * FROM check_todo WHERE id=".$row2->todo." ORDER by id DESC");
while($row3 = mysqli_fetch_object($todo_query))
    {

it's not duplicate and it is not because of the reserved word. It doesn't work with "id" oder "placeholder" (both columns in check_todo) either...

it's not duplicate and it is not because of the reserved word. It doesn't work with "id" oder "placeholder" (both columns in check_todo) either... — David, Jul 13 '16 at 12:28
What does `$row2->todo` contain? The data should escaped with `mysqli_real_escape_string ($db, $row2->todo) ` when using it in the query, unless you have validated it to be safe. — Nisse Engström, Jul 25 '16 at 11:24

Jocelyn · Answer 1 · 2016-07-13T12:24:48.777

0

TYPE is a reserved keyword in MySQL.
Add backticks around it:

$todo_query = mysqli_query($db, "SELECT * FROM check_todo WHERE id=".$row2->todo . 
      " ORDER by `type` ASC");

edited Jul 13 '16 at 12:24

answered Jul 13 '16 at 12:01

Jocelyn

11,209
10
43
60

doesn't work.. textmate shows me "Order" as a syntax-error (wrong color) – David Jul 13 '16 at 12:05
I'm not responsible for the colors in your code editor. – Jocelyn Jul 13 '16 at 12:07
sure you are not :) only wanted to say, that it still doesn't work. – David Jul 13 '16 at 12:07
According to the link you posted, TYPE is not a reserved word. – Your Common Sense Jul 13 '16 at 12:08
@YourCommonSense Check again the link. It is in the rightmost column. – Jocelyn Jul 13 '16 at 12:10
`ORDER by id DESC` doesn't work either.. – David Jul 13 '16 at 12:10
Why a downvote now? – Jocelyn Jul 13 '16 at 12:12

PHP SQL Query ORDER by - Syntax-Mistake?

1 Answers1