note 104797 added to mysqli.rollback

From: Date: Thu, 07 Jul 2011 15:47:45 +0000
Subject: note 104797 added to mysqli.rollback
Groups: php.notes 
Request: Send a blank email to php-notes+get-181332@lists.php.net to get a copy of this message
In regards to the note posted by jd at dilltree dot com: The reason your DELETE statement doesn't work after a rollback is that you are either forgetting to COMMIT the delete or haven't turned autocommit back on. If you fail to do either of those and the script terminates then an auto-rollback gets performed and your DELETE never happens, thus the deleted rows reappear. ---- Server IP: 69.147.83.197 Probable Submitter: 216.17.68.195 ---- Manual Page -- http://www.php.net/manual/en/mysqli.rollback.php Edit -- https://master.php.net/note/edit/104797 Del: integrated -- https://master.php.net/note/delete/104797/integrated Del: useless -- https://master.php.net/note/delete/104797/useless Del: bad code -- https://master.php.net/note/delete/104797/bad+code Del: spam -- https://master.php.net/note/delete/104797/spam Del: non-english -- https://master.php.net/note/delete/104797/non-english Del: in docs -- https://master.php.net/note/delete/104797/in+docs Del: other reasons-- https://master.php.net/note/delete/104797 Reject -- https://master.php.net/note/reject/104797 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#181332) next »