Edit report at https://bugs.php.net/bug.php?id=51724&edit=1
ID: 51724 Updated by: php-bugs@lists.php.net Reported by: jerck at rocware dot com Summary: int PDO::exec ( string $statement ) -Status: Feedback +Status: No Feedback Type: Bug Package: PDO related Operating System: Mac OS X 10.5.8 PHP Version: 5.2SVN-2010-05-03 (SVN) Assigned To: pierrick New Comment: No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Open". Thank you. Previous Comments: ------------------------------------------------------------------------ [2010-05-03 15:26:33] pierr...@php.net Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.php.net/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to "Open". Thank you for your interest in PHP. It seems to work properly. Could you try to execute the following statement before executing your script to make sure that the row you're trying to modify will really be affected by your query. UPDATE `Business` SET `Business`.`Phone` = '' WHERE `Business`.`BusinessID` = 1 ------------------------------------------------------------------------ [2010-05-03 03:26:32] jerck at rocware dot com Description: ------------ Explained succinctly in "test script" text area below... <?php // Back ticks do not adversely affect SQL. It runs without error. $sql = " UPDATE `Business` SET `Business`.`Phone` = '1 (612) 986-6874' WHERE `Business`.`BusinessID` = 1 LIMIT 1"; $count = DB::I()->exec($sql); // Singleton PDO DB handle echo($count); // prints 0 of type integer /** * $count should evaluate to the integer 1, not to 0. * Thoughts? **/ ?> Test script: --------------- <?php // Back ticks do not adversely affect SQL. It runs without error. $sql = " UPDATE `Business` SET `Business`.`Phone` = '1 (612) 986-6874' WHERE `Business`.`BusinessID` = 1 LIMIT 1"; $count = DB::I()->exec($sql); // Singleton PDO DB handle echo($count); // prints 0 of type integer /** * $count should evaluate to the integer 1, not to 0. * Thoughts? **/ ?> Expected result: ---------------- echo($count); // Should print the integer 1 Actual result: -------------- echo($count); // Currently prints the integer 0 even though the database is successfully updating 1 record ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=51724&edit=1
