Hi I've written a query that pulls information from a calendar
$result=mysql_query("select start_time, end_time, room_id, name, description, mobile_no from mrbs_entry, mrbs_tel where mrbs_entry.room_id = mrbs_tel.contact_id and start_time >= '$today_start' and end_time < '$today_end'");
while ($i = mysql_fetch_row($result))
now the problem that I am having is that there can be moer than one room_id for each day and I need to be able to merge the data from multiple room_id's.
Can anyone please help me. Please ask if you need any further inforamtion.