Php/mysql code in VBulletin templates

[deni_z]

Hi everybody!

I want to make a modification to my forum. I don't want to bore you with all the details. For now I added a "my_keyword" to thread table in the database, and now I just want to display it next to the thread title.

In forumhome_forumbit_level2_post I did this:

<td class="alt1Active" align="$stylevar[left]" id="f$forum[forumid]">
		<div>
$rr = $vbulletin->$db->query_first("SELECT oras FROM af_thread WHERE userid = " . $forum[forumid] . "); 

			<a href="forumdisplay.php?$session[sessionurl]f=$forum[forumid]"><strong>$forum[title] - $rr </strong>

and the result is in the picture...

So, my question is: How to make it work?