note 91301 added to pdostatement.execute
| From: | nicolas dot baptiste at gmail dot com | Date: | Thu, 04 Jun 2009 14:15:48 +0000 |
| Subject: | note 91301 added to pdostatement.execute | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-156362@lists.php.net to get a copy of this message | ||
Weird diference between php versions when using the same parameter twice in a request
$sql = 'SELECT * FROM (
(SELECT COUNT(id) AS nbPosts FROM post WHERE sujet_id IN
(SELECT id FROM sujet WHERE forum_id = :id)) AS t1
,
(SELECT COUNT(id) AS nbPostsRecents FROM post WHERE sujet_id IN
(SELECT id FROM sujet WHERE forum_id = :id)
AND DATEDIFF(now(),publication) <= 0) AS t2)';
$rs = parent::preparedSelect($sql,);
$stm = $this->cnx->prepare($sql);
$rs = $stm->execute(array(':id'=>1));
Under php 5.2.1 Gentoo :
Warning: PDOStatement::execute() [function.PDOStatement-execute]: SQLSTATE[HY093]: Invalid parameter
number: number of bound variables does not match number of tokens in ...
Under php 5.2.9-1 Windows :
Works fine
----
Server IP: 89.31.146.176
Probable Submitter: 90.12.147.153
----
Manual Page -- http://www.php.net/manual/en/pdostatement.execute.php
Edit -- https://master.php.net/note/edit/91301
Del: integrated -- https://master.php.net/note/delete/91301/integrated
Del: useless -- https://master.php.net/note/delete/91301/useless
Del: bad code -- https://master.php.net/note/delete/91301/bad+code
Del: spam -- https://master.php.net/note/delete/91301/spam
Del: non-english -- https://master.php.net/note/delete/91301/non-english
Del: in docs -- https://master.php.net/note/delete/91301/in+docs
Del: other reasons-- https://master.php.net/note/delete/91301
Reject -- https://master.php.net/note/reject/91301
Search -- https://master.php.net/manage/user-notes.php