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