par
ma_pomme » 07 juil. 2005, 21:14
alors je ne connait rien dans ce domaine mais j'ai essayé de piqué un bout de code qui appel cette meme variable mais ça ne marche pas

c'est ça
$sql = "SELECT t1.*, t2.username
FROM " . LOTTERY_HISTORY_TABLE . " as t1, " . USERS_TABLE . " as t2
WHERE t2.user_id = t1.user_id
ORDER BY time DESC";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_selecting'], 'lottery history'), '', __LINE__, __FILE__, $sql);
}
if ( $db->sql_numrows($result) > 0 )
{
if (!( $row = $db->sql_fetchrow($result) ))
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_selecting'], 'lottery'), '', __LINE__, __FILE__, $sql);
}
$template->assign_block_vars('switch_last_winner', array(
'WINNER_NAME' => $row['username']));
}
alors je ne connait rien dans ce domaine mais j'ai essayé de piqué un bout de code qui appel cette meme variable mais ça ne marche pas :( c'est ça
[php]$sql = "SELECT t1.*, t2.username
FROM " . LOTTERY_HISTORY_TABLE . " as t1, " . USERS_TABLE . " as t2
WHERE t2.user_id = t1.user_id
ORDER BY time DESC";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_selecting'], 'lottery history'), '', __LINE__, __FILE__, $sql);
}
if ( $db->sql_numrows($result) > 0 )
{
if (!( $row = $db->sql_fetchrow($result) ))
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_selecting'], 'lottery'), '', __LINE__, __FILE__, $sql);
}
$template->assign_block_vars('switch_last_winner', array(
'WINNER_NAME' => $row['username']));
} [/php]