ID: 36053
Updated by: [EMAIL PROTECTED]
Reported By: tzlee at tzlee dot com
-Status: Assigned
+Status: Feedback
Bug Type: PDO related
Operating System: Linux
PHP Version: 5.1.2
Assigned To: wez
New Comment:
What version of MySQL are you using?
Previous Comments:
------------------------------------------------------------------------
[2006-01-17 16:22:03] [EMAIL PROTECTED]
Assigned to the maintainer.
------------------------------------------------------------------------
[2006-01-17 16:19:00] tzlee at tzlee dot com
Description:
------------
Using a param (e.g. :id) more than once in a prepared statement used to
work with my older PHP 5.0.4 (PDO 1.0.2 and PDO_MySQL 1.0.1) but now
breaks with PHP 5.1.2 (using default PDO and PDO_MySQL ext included in
download)
Reproduce code:
---------------
$stmt = $db->prepare("SELECT id, name FROM table WHERE id = :id OR
parent = :id");
$stmt->assignValue(':id', 1, PDO::PARAM_INT);
$stmt->execute();
Expected result:
----------------
Should work
Actual result:
--------------
Failed with General Error
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=36053&edit=1