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>';