Warning: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number

Question

Im having an error with select statment using pdo, and Im not understanding the reason why this is happening.

Do you see something wrong here?

I'm having this error:

Warning: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: parameter was not defined in $readGallery->execute();

$delId = $_GET['delid'];
$thumb = $_GET['thumb'];
$folder = '../uploads/';
$readGallery = $pdo->prepare("SELECT * FROM gallery WHERE news_id = ?");
$readGallery->bindParam(':news_id', $delId);
$readGallery->execute();
$numGallery =   $readGallery->rowCount();

To further elaborate on what @Fred-ii- said, please see this reference material... — War10ck
– War10ck, Commented Apr 7, 2014 at 18:08

Abhik Chakraborty · Accepted Answer · 2014-04-07 18:07:41Z

2

change

$readGallery = $pdo->prepare("SELECT * FROM gallery WHERE news_id = ?");

to

$readGallery = $pdo->prepare("SELECT * FROM gallery WHERE news_id = :news_id");

answered Apr 7, 2014 at 18:07

Abhik Chakraborty

44.9k6 gold badges56 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Funk Forty Niner Over a year ago

Weren't you supposed to be having lunch? lol +1 for ya, why not ;-)

Abhik Chakraborty Over a year ago

well I belong to a timezone where its almost Tuesday 8th march 2014 :-)

Funk Forty Niner Over a year ago

Breakfast then, or late night snack ;-) It's lunchtime here.

Collectives™ on Stack Overflow

Warning: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related