Tool mit Smarty

[SlimShady95]

Also so:

Code:

{php} $result_vil = mysql_query('SELECT * FROM `villages` WHERE `id` = ' . mysql_escape_string($_GET['village'])); $data_vil = mysql_fetch_assoc($result_vil); $result_user = mysql_query('SELECT * FROM `users` WHERE `id` = ' . mysql_escape_string($data_vil['userid'])); $data_user = mysql_fetch_assoc($result_user); // Den Usernamen in Smarty speichern $this->_tpl_vars['user'] = $data_user; {/php}

Ungetestet, sollte aber funzen

Edit: Username wäre dann {$user.username}

MfG Manuel