note 120963 added to mysqli.affected-rows

While using prepared statements, even if there is no result set (Like in an UPDATE or DELETE), you still need to store the results before affected_rows returns the actual number: <?php $del_stmt->execute(); $del_stmt->store_result(); $count = $del_stmt->affected_rows; ?> Otherwise things will just be frustrating .. ---- Server IP: 72.52.91.14 Probable Submitter: 76.79.190.130 ---- Manual Page -- http://php.net/manual/en/mysqli.affected-rows.php Edit -- https://master.php.net/note/edit/120963 Del: integrated -- https://master.php.net/note/delete/120963/integrated Del: useless -- https://master.php.net/note/delete/120963/useless Del: bad code -- https://master.php.net/note/delete/120963/bad+code Del: spam -- https://master.php.net/note/delete/120963/spam Del: non-english -- https://master.php.net/note/delete/120963/non-english Del: in docs -- https://master.php.net/note/delete/120963/in+docs Del: other reasons-- https://master.php.net/note/delete/120963 Reject -- https://master.php.net/note/reject/120963 Search -- https://master.php.net/manage/user-notes.php