Here is my problem:

I have a db of events with categories and locations. A form w/ checkboxes inserts into 2 tables the following:

Table 1: event
(id, title, date, description, contact)

Table 2: event_search (only foreign keys)
(event_id,location_id,type_id)

2 other tables are listing the locations and the types

Table 3: location (International, national, all 50 us states)
(id, name)

Table 4: event_type (promotional, free, concert...)
(id, name)

Some events have multiple types and locations, so this is the only way I've figured out to have a normalized db.

How can I list the events, displaying their locations and type, without using GROUP_CONCAT (only works w/ mySQL 4.1 )

?????????????????????????????????????????????????? ??????????