How to correctly insert variables into this query?

Question

PHP

$query='SELECT*FROM answer WHERE title="'.$row['title'].'" ORDER BY id DESC LIMIT "'.$art.'", "'.$kol.'"';
Gives 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 '"0", "3"' at line 1

Answer 1

sprintf? And Limit must have numeric values, and you place a string there, i.e. remove the double quotes.

Answer 2

The best option would be to use placeholders.
But in your case you can do this:

$query = "SELECT * FROM answer WHERE title='{$row['title']}' ORDER BY id DESC LIMIT {$art}, {$kol}";