Hi
I would like to get all the phone numbers from a table who has the event code for a given event (i have many phone numbers for one event) from a event table.
I am doing :
while($recordset->getrow()){
//data from event table
if($recordset-field(event_id)==$recordset-field(event_fid)){
//data from event_phone table with the current event id
}
}
But this code displays the same event twice with two diferent phone numbers
I am also doing :
LEFT JOIN event_phone ON event.event_id = event_phone.event_fid
How can i display all the phone numbers from one given event ??
thank´s in advance
