In einer Abfrage mehrere Zeilen auswählen ?

[Antman]

Hallo,

also ich möchte auf der Newsseite die neuesten produkte listen. Zu jdem Produkt kann es aber mehrere Kommentare von Experten geben.

Leider wird nur immer ein Kommentar ausgegegen(gefunden).

/* retrieve latest products */
$res =& $db->query("
SELECT p1.name, p1.since, p2.pid, p3.picture, p4.produktbeschreibung,
       p5.comment, p6.name_f, p6.name_l, p6.pic,           concat(p7.picture, '_', p7.width, 'x', p7.height, '.', p7.ext)
       AS pic_person

FROM (products p1
INNER JOIN lnk_product_pic p2 on p1.pid = p2.pid
INNER JOIN picture p3 on p3.id_pic = p2.id_picture)
INNER JOIN productinfo p4 on p1.pid = p4.pid
LEFT JOIN products_comments p5 on p4.pid = p5.pid
LEFT JOIN contacts p6 on p5.id_person = p6.id
LEFT JOIN contacts_pictures p7 on p7.id_contact = p6.id
WHERE p1.since between year(CURDATE())-1 and year(CURDATE())
AND  lang = '".$language."'
ORDER BY p1.since DESC");

Weiß jemand wie das geht ? Danke