[anarx]

Hi!

I have got a new question:
I use $WQ_last10threadfromforum2 to show some threads.

I included the table "forum" to show the forum name.

SELECT thread.threadid, thread.title as threadtitle, thread.postusername,thread.postuserid,thread.dateline,forum.title,forum.forumid, forum.parentid

FROM thread
LEFT JOIN forum
ON (thread.forumid = forum.forumid)

Showing the forumname just works fine with "title"

Now I wanted to show the names of one parent forum, too.

First I tried it with "parentid" and "title" but it did not show me the name of the parent forum, it just showed me the name of the forum where the thread is.

After that did not work I tried it like that:

<td class="$alternate" WIDTH="12%" VALIGN="TOP" NOWRAP><div class="smallfont">

<if condition="$WQfield[forumid]=='40'">
<a href='forumdisplay.php?$session[sessionurl]f=$WQfield[forumid]'>
BLA</a>
</if>
<if condition="$WQfield[forumid]=='38'">
<a href='forumdisplay.php?$session[sessionurl]f=$WQfield[forumid]'>
BLUB</a></if>
<else>
<a href='forumdisplay.php?$session[sessionurl]f=$WQfield[forumid]'>
Bla2</a></else>

</div></td>

That did not work, too.

I hope you understand my problem. I am not good at coding. Please help me if you are able to.

cU anarx