renvois valeurs vers table sql

<?php
$db = mysql_connect('localhost', 'root', '') or die('HOST ?');
mysql_select_db('Adherents',$db) or die('DB ?');

/*if (isset($_POST['choix'])) {
echo "Vous avez choisi :";
for ($i = 0, $c = count($_POST['choix']); $i < $c; $i++) {
echo "<br/><b>" . $_POST['choix'][$i] . "</b>";
}
}*/

mysql_query ("INSERT INTO sortie ( Nom, Prenom, Classe, Telephone, Portable_M, Portable_P, Sortie, Photos )

SELECT Nom, Prenom, Classe, Telephone, Portable_M, Portable_P, Sortie, Photos FROM enfants") ;


// mysql_query($sql) or die(mysql_error());

header ('location: tri.php');?>

echo '<div align="center"><p>Cochez les cases voulues puis Validez</p>';
echo '<table border="1">'; 
echo '<tr><td>id</td><td>Nom</td><td>Prenom</td><td>Classe</td><td>Date_naissance</td><td>Telephone</td><td>Portable_M</td><td>Portable_P</td><td>Adresse</td><td>E_mail</td><td>Sortie</td><td>Photos</td><td>Choix</td></tr>';
while($data = mysql_fetch_assoc($req)){ 
/*conversion de la date au format Français */ 
 
$date=explode('-',$data['Date_naissance']); 
$date=$data['Date_naissance']=$date[2].'-'.$date[1].'-'.$date[0]; 
/* 
$a = substr($data['Date_naissance'], 0, 4); 
$m = substr($data['Date_naissance'], 5, 2); 
$j = substr($data['Date_naissance'], 8, 2); 
$date = $j.'-'.$m.'-'.$a; 
*/ 
echo '<tr>
	  <td><input type="checkbox" name="choix[]" value"'.$data['id'].'">'.$data['id'].'</td>
	  <td><input type="checkbox" name="choix[]" value"'.$data['Nom'].'">'.$data['Nom'].'</td>
	  <td><input type="checkbox" name="choix[]" value"'.$data['Prenom'].'">'.$data['Prenom'].'</td>
	  <td><input type="checkbox" name="choix[]" value"'.$data['Classe'].'">'.$data['Classe'].'</td>
	  <td>'.$date.'</td>
	  <td><input type="checkbox" name="choix[]" value"'.$data['Telephone'].'">'.$data['Telephone'].'</td>
	  <td><input type="checkbox" name="choix[]" value"'.$data['Portable_M'].'">'.$data['Portable_M'].'</td>
	  <td><input type="checkbox" name="choix[]" value"'.$data['Portable_P'].'">'.$data['Portable_P'].'</td>
	  <td>'.$data['Adresse'].'</td>
	  <td>'.$data['E_mail'].'</td>
	  <td><input type="checkbox" name="choix[]" value"'.$data['Sortie'].'">'.$data['Sortie'].'</td>
	  <td><input type="checkbox" name="choix[]" value"'.$data['Photos'].'">'.$data['Photos'].'</td></tr>';
	  /*<td><input type="checkbox" name="choix[]" value=""></td></tr>';*/
	  /*,'.$data['Prenom'].','.$data['Classe'].','.$data['Telephone'].','.$data['Portable_M'].','.$data['Portable_P'].','.$data['Sortie'].'*/
	   
} 
 
echo '</table>'; 
 
echo '</div><hr>';
 
echo '<div align="center"><a href="choix.php"><input type="submit" value="valider" name="yes"></a></div>';
 
}else{
 
$sql = 'SELECT * FROM enfants'; 
$req=mysql_query($sql) or die ('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());