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]

Originally Posted by 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

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.