Limit not working in SQL statement with Variable

Question

The following statement written in php for a mysql database always brings me the 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 ''10'' at line 1'".

('SELECT `creator`,`created`,`content` 
FROM mytable 
WHERE `groupid`=? 
ORDER BY `created` DESC 
LIMIT ?', $foo, 10)

When I replace the questionmark with a number, it works.

Where is my mistake?

Bind variables can't be applied to limits, in the same way you can't use bind variables for table names or column names, order direction, etc — Mark Baker
– Mark Baker, Commented Nov 8, 2014 at 14:47
Why? Because of the way bind variables actually work, and what they actually do..... they're not simply a plug-and-play anywhere in a query, but are specific to dynamic arguments used in your WHERE clause — Mark Baker
– Mark Baker, Commented Nov 8, 2014 at 15:24

Ido · Accepted Answer · 2014-11-08 14:46:42Z

1

You can't bind number to the LIMIT .. just add it to the actual query:

('SELECT `creator`,`created`,`content` 
FROM mytable 
WHERE `groupid`=? 
ORDER BY `created` DESC 
LIMIT ' . 10, $foo)

answered Nov 8, 2014 at 14:46

Ido

2,0541 gold badge19 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

Limit not working in SQL statement with Variable

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related