...

View Full Version : Matching value in a query



bensoir
02-01-2007, 11:00 AM
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.

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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum