Mysql PHP LIMIT 1 Error

Question

I have the following code:(php)

$alert = mysqli_query($con,"SELECT * FROM 'user_" . $row['id'] . "_notifications' LIMIT 1");

which gives me this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''user_2_notifications' LIMIT 1' at line 1

please help me fix this.

Don't quote table (or column) names using '... if you need to quote them, use backticks (`)... Quote characters (') are for string literals — Mark Baker
– Mark Baker, Commented Dec 17, 2013 at 23:23
Which bit of it do you want help with fixing? The part where you use data as table names? The part where you apply a LIMIT to a query without specfying an ORDER BY thereby giving unpredictable results? Or the syntax error? — symcbean
– symcbean, Commented Dec 18, 2013 at 0:12

vee · Accepted Answer · 2013-12-17 23:23:33Z

2

Get rid of the single quotes around the table name in your query:

$alert = mysqli_query($con,"SELECT * FROM user_" . $row['id'] . "_notifications LIMIT 1");

You only need to escape table names and column names if they are one of the MySQL Reserved Words. The escape character in that case is back tick (`) not single quote (') like you've in your query.

answered Dec 17, 2013 at 23:23

vee

38.7k7 gold badges76 silver badges80 bronze badges

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

2 Comments

Bell Over a year ago

Or escape them like this: `foo`

Ethan McTague Over a year ago

Thank you! This worked quite well. I have actually found this in many places in my code, and I have now fixed it!

Collectives™ on Stack Overflow

Mysql PHP LIMIT 1 Error

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related