Problem with foreach loop?

[jenny kaur]

[code]

This is my db

+----+------------+--------------+--------------+----------+
| id | bookdate   | Enddate      | Room_number  |   Guest  |
+----+------------+--------------+--------------+----------+
| 1  | 1149609600 | 1149695999   |       1      |   Jones  |
+----+------------+--------------+--------------+----------+
| 1  | 1149523200 | 1149609599   |       1      |   Smith  |
+----+------------+--------------+--------------+----------+

[/code]

below is my code

[code]
<?php




[code]

This is what i get output on screen  

+---------+------------+------------+-----------+
| Room #  | 06/05/2006 |06/06/2006  |06/07/2006 |
+---------+------------+------------+-----------+
|     1   |            |   Jones    |           |      
+---------+------------+------------+-----------+
|     1   |   Smith    |            |           |
+---------+------------+------------+-----------+
[/code]

i am trying to get room 1 displayed once and Smith and Jones in the same row. like this:

[code]
+---------+------------+------------+-----------+
| Room #  | 06/05/2006 |06/06/2006  |06/07/2006 |
+---------+------------+------------+-----------+
|     1   | Smith      |   Jones    |           |      
+---------+------------+------------+-----------+

[/code]

can someone tell me where i am going wrong?