echo ''; $sql2 = mysql_query("SELECT * FROM `rooms` WHERE `res_num` = '$conf' AND `room` = '$room' ORDER BY `date`"); while ($room_night = mysql_fetch_object($sql2)) { $date = $room_night->date; echo ''; } echo ''; while ($room_night = mysql_fetch_object($sql2)) { $date = $room_night->date; $adults = $room_night->adults; $children = $room_night->children; $young_children = $room_night->young_children; $pets = $room_night->pets; $smoking = $room_night->smoking; ?>';
Room #'.$room.'
'.date('Y',$date).'-'.date('M',$date).'-'.date('d',$date).'
Adults:
Children (5-12):
Young children (4 and under):
Pets:
Smoking: