[The Red Devil]

hehe yea, I dont know what I was thinking as I didnt look there
Thanks for replying that fast and getting me on the right track again guys.

I got one more question:

Ive gotten it to work now, but I had to add another query (and ofcause I want as few as possible of those)

I had to add this
$lastreply=$DB_site->query_first("SELECT usergroupid FROM user WHERE userid=".$thread['lastposterid']);

Is it possible to add this into the main "thread" query ?
I have already added one in there which get me the usergroupid on the guy that posted the tread.

So what Im wondering on is if its possible for me someway to add another usergroupid into there someway ?

Here is my "threads" query

$threads=$DB_site->query("
SELECT $dotuserid $votequery ".iif($foruminfo[allowicons],'icon.title as icontitle,icon.iconpath,','')."
thread.threadid,thread.title,thread.lastpost, forumid,pollid,open,replycount,postusername,postus erid,
lastposter,lastposterid,user.usergroupid,thread.da teline,views,thread.iconid,notes,thread.visible,st icky,votetotal,attach
FROM thread
".iif($foruminfo[allowicons],'LEFT JOIN icon ON (icon.iconid = thread.iconid)','')."
$dotjoin
LEFT JOIN user ON (thread.postuserid = user.userid)
WHERE $threadids
ORDER BY sticky DESC, $sortfield $sqlsortorder


Thanks