Witam! Mam pewien problem z zapytaniem:

[PHP] pobierz, plaintext 
$max = isSet( $_GET['max'] ) ? intval( $_GET['max'] ) : 0;
[PHP] pobierz, plaintext 

[SQL] pobierz, plaintext 
$tbl = $pdo->prepare( 'SELECT * FROM `posts` ORDER BY id DESC LIMIT 0, :limit ' );
       $tbl->bindParam(':limit', $max);
       $tbl->execute();
[SQL] pobierz, plaintext 

i wyskakuje mi taki error:

Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''0'' at line 1 in D:\xampp\htdocs\Webpage\posts.php:166 Stack trace: #0 D:\xampp\htdocs\Webpage\posts.php(166): PDOStatement->execute() #1 {main} thrown in D:\xampp\htdocs\Webpage\posts.php on line 166

Natomiast jeżeli dla przykładu dam

[SQL] pobierz, plaintext 
WHERE id = :LIMIT
[SQL] pobierz, plaintext 

to wszystko działa

[PHP] pobierz, plaintext 
$tbl->bindParam(':limit', $max, PDO::PARAM_INT);
[PHP] pobierz, plaintext 

Wielkie dzięki, działa