note 63363 added to function.mysql-query

Just realised I posted the wrong functions. Oops! Here you go.... <?php function compile_insert_string($data) { $field_names = ""; $field_values = ""; foreach ($data as $k => $v) { $v = preg_replace( "/'/", "\\'", $v ); //$v = preg_replace( "/#/", "\\#", $v ); $field_names .= "$k,"; $field_values .= "'$v',"; } $field_names = preg_replace( "/,$/" , "" , $field_names ); $field_values = preg_replace( "/,$/" , "" , $field_values ); return array('FIELD_NAMES' => $field_names, 'FIELD_VALUES' => $field_values, ); } //------------------------------------------ // insert_query // // Wrapper for an insert query //------------------------------------------ function insert_query($data, $table) { if (!is_array($data) or count($data) < 1) { $this->fatal_error("Insert data missing"); } $insert = $this->compile_insert_string($data); $query = "INSERT INTO {$table} (".$insert['FIELD_NAMES'].") VALUES (".$insert['FIELD_VALUES'].")"; return $this->query($query); } ?> ---- Server IP: 85.116.0.130 Probable Submitter: 80.168.248.66 ---- 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/63363 Del: integrated -- http://master.php.net/note/delete/63363/integrated Del: useless -- http://master.php.net/note/delete/63363/useless Del: bad code -- http://master.php.net/note/delete/63363/bad+code Del: spam -- http://master.php.net/note/delete/63363/spam Del: non-english -- http://master.php.net/note/delete/63363/non-english Del: in docs -- http://master.php.net/note/delete/63363/in+docs Del: other reasons-- http://master.php.net/note/delete/63363 Reject -- http://master.php.net/note/reject/63363 Search -- http://master.php.net/manage/user-notes.php