note 66759 added to function.mysql-query

Mysql version of multi_query. Unaffected by the ';'s inside quotes. <?php function mysql_multi_query($querystr, $link = NULL) { //seperate the queries by ';' (but not ';' inside quotes) $pattern = "/((('([^\\\\\\\\']*(\\\\\\\\.)*)*'|". "\\\"([^\\\\\\\\\\\"]*(\\\\\\\\.)*)*\\\")+[^;'\\\"]*|". "[^;'\\\"]+('([^\\\\\\\\']*(\\\\\\\\.)*)*'|". "\\\"([^\\\\\\\\\\\"]*(\\\\\\\\.)*)*\\\")*)+)/s"; preg_match_all($pattern, $querystr, $out); $queries = $out[0]; foreach ($queries as $query) if(($query = trim($query)) != '') { if ($link == NULL) $result = mysql_query($query); else $result = mysql_query($query, $link); if(!result) return false; } return $result; //return last result } ?> ---- Server IP: 66.163.161.117 Probable Submitter: 220.58.70.54 ---- X-Spam-Status: No, hits=3.1 required=5.0 tests=DATE_MISSING,FROM_NO_LOWER autolearn=no version=2.64 ---- Manual Page -- http://www.php.net/manual/en/function.mysql-query.php Edit -- http://master.php.net/note/edit/66759 Del: integrated -- http://master.php.net/note/delete/66759/integrated Del: useless -- http://master.php.net/note/delete/66759/useless Del: bad code -- http://master.php.net/note/delete/66759/bad+code Del: spam -- http://master.php.net/note/delete/66759/spam Del: non-english -- http://master.php.net/note/delete/66759/non-english Del: in docs -- http://master.php.net/note/delete/66759/in+docs Del: other reasons-- http://master.php.net/note/delete/66759 Reject -- http://master.php.net/note/reject/66759 Search -- http://master.php.net/manage/user-notes.php