note 125255 added to mysqli.multi-query

To get the affected/selected row count from all queries $q = "UPDATE Review SET order = 1 WHERE id = 600;" // aff 1 . "UPDATE Review SET order = 600 WHERE id = 1;" //aff 1 . "SELECT 0;" //for testing, aff rows == -1 ; $affcnt = 0; $rowcnt = 0; $res = $db->multi_query($q); if($res == false) Lib::throw( $q . "\n[" . $db->errno . "]\n" . $db->error . "\n" ); do { $affcnt += $db->affected_rows; if( isset($res->num_rows) ) $rowcnt += $res->num_rows; } while( $db->more_results() && $res = $db->next_result() ); //IMPORTANT: call more_results First!, THEN next_result to get new data. return $res; ---- Server IP: 45.112.84.4 Probable Submitter: 103.51.166.36 (proxied: 128.72.119.147) ---- Manual Page -- http://php.net/manual/en/mysqli.multi-query.php Edit -- https://master.php.net/note/edit/125255 Del: integrated -- https://master.php.net/note/delete/125255/integrated Del: useless -- https://master.php.net/note/delete/125255/useless Del: bad code -- https://master.php.net/note/delete/125255/bad+code Del: spam -- https://master.php.net/note/delete/125255/spam Del: non-english -- https://master.php.net/note/delete/125255/non-english Del: in docs -- https://master.php.net/note/delete/125255/in+docs Del: other reasons-- https://master.php.net/note/delete/125255 Reject -- https://master.php.net/note/reject/125255 Search -- https://master.php.net/manage/user-notes.php