SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102 [closed]

by

You didn’t bind all your bindings here

$sql = "UNIX_TIMESTAMP(publicationDate) AS publicationDate
        FROM comments WHERE articleid = :art 
        ORDER BY some LIMIT :numRows";

$st = $conn->prepare( $sql );
$st->bindValue( ":art", $art, PDO::PARAM_INT );

You’ve declared a binding called :numRows but you never actually bind anything to it.

More Related Contents:

  1. Query database then email posts from where user is subbed to
  2. Using PHP data in MySQL [closed]
  3. Save the data into a database and return another value from database using PHP
  4. Checking the availability of rooms
  5. How can I do ‘insert if not exists’ in MySQL?
  6. Can I parameterize the table name in a prepared statement?
  7. How to properly set up a PDO connection
  8. Getting raw SQL query string from PDO prepared statements
  9. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  10. MySQL Prepared statements with a variable size variable list
  11. Loading .sql files from within PHP
  12. PDO with INSERT INTO through prepared statements [closed]
  13. Comma separated values in MySQL “IN” clause
  14. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  15. Doing a while / loop to get 10 random results
  16. PHP – Import CSV file to mysql database Using LOAD DATA INFILE
  17. MYSQL Select from tables based on multiple rows
  18. Simple PHP SQL login troubleshooting
  19. Change date format (in DB or output) to dd/mm/yyyy – PHP MySQL
  20. How do you do multiple SQL statements in one mysql_query?
  21. MySql PHP select count of distinct values from comma separated data (tags)
  22. Laravel Eloquent get results grouped by days
  23. MySQL/SQL retrieve first 40 characters of a text field?
  24. How to check if a value already exists to avoid duplicates?
  25. SELECT row by DATEPART()
  26. UNION syntax in Cakephp
  27. MYSQL select a piece of a string and order by that piece
  28. How do i search from serialize field in mysql database?
  29. PHP/MySQL Pagination
  30. Limit pagination page number

Leave a Comment