SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''users' ORDER BY 'ID'' at line 1

Question

I have this line,

$query = "SELECT Food, Calories Title FROM 'users' ORDER BY 'ID'";

I'm so worried about my syntax, when I run it it gives me an error as,

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''users' ORDER BY 'ID'' at line 1

single quote is used to delimit string values, not table and field names. — Uueerdo, Dec 21 '16 at 18:09
Possible duplicate of [When to use single quotes, double quotes, and backticks?](http://stackoverflow.com/questions/11321491/when-to-use-single-quotes-double-quotes-and-backticks) — axiac, Dec 21 '16 at 19:37

score 1 · Answer 1 · answered Dec 21 '16 at 18:17

1

I don't know if you've represented the line exactly as written, but your code lacks a comma after the word 'calories', as in "SELECT Food, Calories, Title FROM 'users' ORDER BY 'ID'"

answered Dec 21 '16 at 18:17

Matthew Ingle

117
3
15

And technically that is allowed, which is why I hate that `As` is optional. – Uueerdo Dec 21 '16 at 18:58

score 0 · Answer 2 · answered Dec 21 '16 at 18:19

0

Try: Select Food, Calories, Title FROM users ORDER BY ID

answered Dec 21 '16 at 18:19

StelioK

1,771
1
11
21

score -1 · Answer 3 · answered Oct 16 '17 at 08:51

-1

$query = "SELECT Food, Calories Title FROM users ORDER BY ID";

answered Oct 16 '17 at 08:51

Hameed Irfan

11
1
5

use (``) this qoutes for food,Calories Title,users and ID – Hameed Irfan Oct 16 '17 at 08:52

SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''users' ORDER BY 'ID'' at line 1

3 Answers3