Running a Query in a template

[VBCoder]

I'd like to have the value of a query (SELECT...) or a function from within a template. Where's the best place for me to put it?

Should I put it in the .php file that calls the template? (I've seen some people put in their global include, but that is very wasteful of resources...)

[Dream]

"hook postbit_create"
$blah = $db->query_read("SELECT * FROM ")
"filter results"
$blah = '<a href="disney.com">' . $filtered . '</a>';

in the postbit template put $blah where you want the text to appear

put the query in a hook and make the variable there... not sure this was the question

[VBCoder]

"hook postbit_create"
$blah = $db->query_read("SELECT * FROM ")
"filter results"
$blah = '<a href="disney.com">' . $filtered . '</a>';

in the postbit template put $blah where you want the text to appear

put the query in a hook and make the variable there... not sure this was the question

Thanks Dream, yes, this is my question.
What do you mean by "filter results"?

[Dream]

well

$result = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "user");
$a = '';
while( $user = $db->fetch_array( $result ) ) {
$a .= "($user[username], userid $user[userid])<br />";
}

then put $a in a template to show the list of users... just an example, hope it helps

if you want just the first row, you could use

$user = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "user");
$a .= "($user[username], userid $user[userid])<br />";

[VBCoder]

Thanks, got it.