我有一个语法错误，它没有意义[重复]

Question

This question already has an answer here:

• Reference - What does this error mean in PHP? 34 answers
• LIMIT keyword on MySQL with prepared statement [duplicate] 2 answers

I don't know why but i have a syntax error, my code looks completely fine to me,

$page = $_POST['page'];
$amount = $_POST['amount'];



$Realpage = intval($page);
$Realamount = intval($amount);
$query = $con->prepare(
   "SELECT 
      * 
    FROM 
      store 
    AS 
      s
    INNER JOIN 
      product_pictures AS pp 
    ON 
      s.product_id = pp.id 
    INNER JOIN 
      product_name AS pn 
    ON 
      s.product_id = pn.id 
    WHERE 
      (s.product_price BETWEEN :firstPrice AND :secondPrice) AND 
      product_name LIKE :input LIMIT :page , :amount ");

$query->execute(array(':input' => "%" . $input . "%" , ":firstPrice" => intval($firstPrice), ":secondPrice" => intval($secondPrice) , ':page' => $Realpage * $Realamount, ':amount' => $Realamount));

Error:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 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' , '20'' at line 1'

</div>

Answer 1

LIMIT and PAGE in your SQL cannot be part of statement preparation.