View Full Version : Matching value in a query

02-01-2007, 12:00 PM
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.

02-01-2007, 09:45 PM
I'm not sure what you mean by "merge".