rendered paste body echo '<table border="1">
<tr>
<td colspan="'.$num_nights.'">Room #'.$room.'</td>
</tr>
<tr>';
$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 '<td>'.date('Y',$date).'-'.date('M',$date).'-'.date('d',$date).'</td>';
}
echo '</tr>';
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;
?><tr><td>
Adults: <?php generate_number_select(2, 6, "adults[$room][$date]");?><br />
Children (5-12):<?php generate_number_select(0, 4, "children[$room][$date]");?><br />
Young children (4 and under):<?php generate_number_select(0, 4, "young_children[$room][$date]");?><br />
Pets:<?php generate_number_select(0, 4, "pets[$room][$date]");?><br />
Smoking:<?php generate_boolean(0,"smoking[$room][$date]");?><br />
</td></tr>
<?php
}
echo '</table>';