mySQL/php Und noch mal SELECT & JOINS

[Teiger]

Hallo,

die alte abfrage nehmen und die neuen tabellen einbauen. dazu muss man aber den aufbau der neuen beziehungstabelle kennen.

Tabelle 1: events
-----------------------------
id|headline|txt

Tabelle 2: lnk_event_contacts
------------------------------
id_event|id_contacts

Tabelle 3: lnk_event_employees
------------------------------
id_event|id_employees

Tabelle 4: lnk_event_pic
------------------------------
id_event|id_pic

Tabelle 5: employees
-------------------------------
id|emloy_id|name|email|function|tel ..... etc

Tabelle 6: contacts
-------------------------------
id|company|name|email

Tabelle 7: pictures_events
-------------------------------
id|picture|description

Hier das SQL-Statement:

SELECT e.*, c.*, pe.picture, pe.description
FROM lnk_event_conductor AS lec, contacts AS c, events e
LEFT JOIN lnk_event_pic AS lep ON (e.id = lep.id_event)
LEFT JOIN pictures_events AS pe ON (lep.id_event = pe.id)
WHERE e.lang = '".$this->language."'
AND (e.id = 'id_nummer')
AND (e.id = lec.id_event)
AND (lec.id_event = c.id);

OK, so sieht es nun aus. Aber wie weiter?

Gruß Teiger