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