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 29
|
$sql = "SELECT chambr FROM chambrevoulue";
//echo $sql."<br>";
$quer = mysql_query($sql) or die (mysql_error());
while($fe = mysql_fetch_array($quer)) ==> l'erreur se trouve sur cette ligne
{
echo $fe[0]."numero de chambre<br>";
$sql2= "SELECT num_categorie FROM appartenir WHERE num_chambre = '".$fe[0]."'";
echo $sql2." selection de num_categorie des chambres<br>";
$quer2 = mysql_query($sql2) or die (mysql_error());
while ( $fe2 = mysql_fetch_array($quer2))
{
$insert = "INSERT INTO reserver(num_chambre, nbre_personne, id_client, nbre_chambre, date_arrivee, date_depart)
VALUES ( '".$fe[0]."', '' , '', '', '', '')";
echo $insert."<br>";
$quer = mysql_query($insert) or die (mysql_error());
$aff = mysql_affected_rows();
/*$req = "SELECT tarif FROM categorie WHERE num_categorie = ".$fe2[0]."";
$querreq = mysql_query($req);
$fereq = mysql_fetch_array($querreq); */
echo $fe[0]." Numero de chambre de type ".$fe2[0]." <br>";
}
} |
Partager