1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
|
$sql1 = "SELECT num_chambre
FROM appartenir
WHERE num_categorie = '".$personne."'
AND num_chambre NOT IN
(
SELECT num_chambre
FROM reserver
WHERE date_arrivee = '".$date_arrivee."'
OR date_depart = '".$date_depart."'
)LIMIT 0,".$nombre * $nbNuit."";
$tab_com = mysql_query($sql1) or die('Erreur SQL !'.$sql1.'<br>'.mysql_error());
while ($fe = mysql_fetch_array($tab_com))
{
echo $fe[0]."num chambre de type 1<br>";
if ($id_client= mysql_insert_id())
{
$requete66 = "INSERT INTO reserver (num_chambre, id_client, num_reservation, date_arrivee, date_depart, nbre_chambre, nbre_personne)
VALUES ('".$fe[0]."', '".$id_client."', '".$num_reservation."', '$date_arrivee', '$date_depart', '$nombre', '$personne')" ;
echo $requete66."insertion reserver nouvo client<br>";
$req66 = mysql_query ($requete66);
$rowaddreserve = mysql_affected_rows();
}
} |
Partager