for each problem showing row twice

[nicky77uk1]

<?php
			while ($row= mysql_fetch_array($res2)) {
				$string = null;


			$room_number = $row['room_number'];
			$room_start_date_ts = $row['bookdate'];
			$room_end_date_ts = $row['enddate'];
					$guest = $row['guest'];

			$string = "<td bgcolor=lightgrey align=center>$room_number</td>";


			foreach ($dates as $curr_date) {
				if ($curr_date >= $room_start_date_ts && $curr_date < $room_end_date_ts) {
					$string .= "<td bgcolor=red align=center>$guest</td>";
					$booked++;
				} else {
					$string .= "<td bgcolor=green align=center>Free</td>";
				}
			} // e

			echo "<tr>$string<td bgcolor=lightgrey align=center>$booked</td></tr>";
		} 
	} 
} 
} 

echo "</table>";
?>

[ahundiak]

I think you are actually pretty close. Need to move your row echo statement outside of your while loop.

$query2 = "select * from room where room_number = '$room'"; 
while ($row= mysql_fetch_array($result_of_query2)) {
  // Build your booking string by looping through dates
}
echo Booking String

By the way this is classic example of why seperating content from presentation is often a good thing. All the html code you have in there makes it difficult to read the code and even more difficult to modify it.

Have one section (perhaps a function) which queries the database, figues out which rrom is booked for which date and stores everything nicely into an array.

Then have a second routine which process the array and generates the html.

[nicky77uk1]

im sorry i didnt understand how to implement the adive you gave me? 😕