1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| $retour = mysql_query("select c.nom_client, c.prenom_client, date_format(r.Date_arrivee_reservation, '%d/%m/%Y') as date_arrivee, date_format(r.Date_retour_reservation, '%d/%m/%Y') as date_retour, r.montant_reservation, date_format(r.Date_reservation, '%d/%m/%Y') as date_resa
from client c, reservation r
where (c.ref_client=r.ref_client and date_arrivee_reservation>=20080601)") or die(mysql_error());
while ($donnees = mysql_fetch_array($retour));
{
$nom[] = $donnees['nom_client'];
$prenom[] = $donnees['prenom_client'];
$date_arrivee[] = $donnees['date_arrivee'];
$date_retour[] = $donnees['date_retour'];
$montant[] = $donnees['montant_reservation'];
$date_reservation[] = $donnees['date_resa'];
}
echo '<pre>';
print_r($montant);
echo '</pre>';
echo count($montant);
mysql_close(); |
Partager