Error while using PDO prepared statements and LIMIT in query [duplicate]

by

You can do like this:

$sql = SELECT * FROM tbl_news ORDER BY date DESC LIMIT :start, :rows";
$q = $db->prepare($sql);
$q->bindParam(':start', $start, PDO::PARAM_INT);
$q->bindParam(':rows',$rows, PDO::PARAM_INT);

More Related Contents:

  1. PHP – Using PDO with IN clause array
  2. LIMIT keyword on MySQL with prepared statement [duplicate]
  3. pdo prepared statements with wildcards
  4. Can I use a PDO prepared statement to bind an identifier (a table or field name) or a syntax keyword?
  5. Insert multiple rows with PDO prepared statements
  6. Replacing mysql_* functions with PDO and prepared statements
  7. PDOstatement (MySQL): inserting value 0 into a bit(1) field results in 1 written in table
  8. Calling stored procedure with Out parameter using PDO
  9. When *not* to use prepared statements?
  10. PDO error: SQLSTATE[HY000]: General error: 2031
  11. Use of PDO in classes [duplicate]
  12. Can I mix MySQL APIs in PHP?
  13. Can I bind an array to an IN() condition in a PDO query?
  14. PDOException “could not find driver”
  15. PDO get the last ID inserted
  16. How do I use password hashing with PDO to make my code more secure? [closed]
  17. MySQLi prepared statements error reporting [duplicate]
  18. PDO::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers
  19. Insert/update helper function using PDO
  20. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  21. Is “SET CHARACTER SET utf8” necessary?
  22. Retrieve (or simulate) full query from PDO prepared statement
  23. Set PDO to throw exceptions by default [duplicate]
  24. PDO: MySQL server has gone away
  25. return multiple response data in one response
  26. How to get a query error from prepare() in PDO PHP?
  27. PHP PDO how to run a multiple query request?
  28. PDO bindParam into one statement?
  29. What is the PDO equivalent of function mysql_real_escape_string?
  30. Installing PDO driver on MySQL Linux server

Leave a Comment