![]() |
Query table and then display in postbit
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:
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? |
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:
PHP Code:
$myvalue where ever you want it to display. Hope this helps some :) |
All times are GMT. The time now is 10:00 PM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|