1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| //Insertion du film
$sql='INSERT INTO film (Id,Film,Id_Realisateur,Id_Genre,Id_Nationalite,Id_Distribution,DateSortie,Chemin_Photo,Duree,Resume)
SELECT "\N",
"'.$_POST['Titre'].'",
Id FROM realisateur WHERE Realisateur = "'.$_POST['Realisateur'].'",
Id FROM genre WHERE Genre = "'.$_POST['Genre'].'",
Id FROM nationalite WHERE Nationalite = "'.$_POST['Nationalite'].'",
Id FROM distribution WHERE Distribution = "'.$_POST['Distribution'].'",
"'.$_POST['Date'].'",
"TEST",
"'.$_POST['Duree'].'",
"'.$_POST['Resume'].'"';
$req=mysql_query($sql);
mysql_close($idcom);
} |
Partager