note 91301 rejected from pdostatement.execute by danbrown
| From: | danbrown@php.net | Date: | Thu, 04 Jun 2009 14:18:37 +0000 |
| Subject: | note 91301 rejected from pdostatement.execute by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-156363@lists.php.net to get a copy of this message | ||
Note Submitter: nicolas dot baptiste at gmail dot com
----
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