Query table and then display in postbit

[Gearloose]

I have a custom table with some fields like this:
sometable(someid, somethreadid, someuserid, somefield1, somefield2)

How can I display in postbit (e.g. under posts#) the value in somefield1 and somefield2, based on threadid and userid?

I guess I have to use a variable (let's say $myvalue) in postbit template which takes a value by a query like:

PHP Code:

        $myvalue = $DB_site->query_first("
                SELECT somefield1, somefield2
                FROM " . TABLE_PREFIX . "sometable
                WHERE (somethreadid = " . intval($threadid) . ") 
                AND (someuserid = " . intval($userid) . ") 
        "); 


where: $threadid -> the thread I view
and: $userid -> the userid of each user's post in this thread
(The pair somethreadid/someuserid is unique in the table.)

Then I guess I have to use $myvalue[somefield1] and $myvalue[somefield2] in the template.

Is this correct?
How can I accomplish this?
Should I make a new php file or add this query in an existing one?
What else should I add in the php file besides this query?
Do I have to make a new teplate, or just add this variable in postbit?
Any help?

[ericgtr]

Well, whether or not you want to add a new template for it is up to you. Let's say it's something you want to spit out on your forumhome, you could add the query to index.php and then call it up in your forumhome (corresponding) template.

Here is an example of how that could be done:

in index.php you could find:

PHP Code:

// ### ALL DONE! SPIT OUT THE HTML AND LET'S GET OUTA HERE... ### 


Add your query above it:

PHP Code:

$myvalue = $DB_site->query_first(" 
                SELECT somefield1, somefield2 
                FROM " . TABLE_PREFIX . "sometable 
                WHERE (somethreadid = " . intval($threadid) . ") 
                AND (someuserid = " . intval($userid) . ") 
        "); 


The call it up in your forumhome template with your variable
$myvalue
where ever you want it to display.

Hope this helps some