Running a Query in a template

[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 />";