Code: Selecteer alles
$sql = "SELECT * FROM " . TOPICS_TABLE . " ORDER BY `topic_id` DESC LIMIT 0, 10";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query posts', '', __LINE__, __FILE__, $sql);
}
if ( $row = $db->sql_fetchrow($result) )
{
$i = 0;
do
{
$template->assign_block_vars('rowwe', array(
'topicid' => $row[topic_id],
'title' => $row[topic_title],
'vieuws' => $row[topic_views],
'forumid' => $row[forum_id],
'poster' => create_date("m/d/Y - h:i:s", $row[topic_time], $board_config['board_timezone']),
'replies' => $row[topic_replies])
);
$count = $i;
$i++;
}
while ( $row = $db->sql_fetchrow($result) );
$db->sql_freeresult($result);
}
iemand een ideetje hoe ik de naam kan krijgen ?
tnx