$values = array(); foreach($data as $row ) { $values[] = '('.$row['id'].', "'.mysql_real_escape_string($row['name']).'")'; } mysql_query('INSERT INTO table (id, name) VALUES '.implode(',', $sql));