SELECT
prefix_forums.id as fid,
prefix_forums.name as fname,
prefix_forums.pos as fpos,
case when view <= 0 then vg.name else vt.name end as view,
case when reply <= 0 then rg.name else rt.name end as reply,
case when start <= 0 then sg.name else st.name end as start
FROM prefix_forums
LEFT JOIN prefix_grundrechte as vg ON prefix_forums.view = vg.id
LEFT JOIN prefix_grundrechte as rg ON rg.id = prefix_forums.reply
LEFT JOIN prefix_grundrechte as sg ON sg.id = prefix_forums.start
LEFT JOIN prefix_groups as vt ON prefix_forums.view = vt.id
LEFT JOIN prefix_groups as rt ON rt.id = prefix_forums.reply
LEFT JOIN prefix_groups as st ON st.id = prefix_forums.start
WHERE prefix_forums.cid = ".$row['id']." ORDER BY prefix_forums.pos"
Ich habe in der Table forums das Field pmgroup hinzugefügt. In diesem Feld wird die ID einer Gruppe gespeichert. Ich möchte also die QRY wiefolgt erweitern:
- hole den Wert aus forums.pmgroup und gib mir dann aber den Namen der Gruppe zurück
Kann mir jemand sagen, inwiefern ich die QRY dann anpassen muss?
verwendete ilchClan Version: 1.1
betroffene Homepage: my-sox.de
