naam van poster

[Montana]

ik heb deze code op me site staan om de 10 laatste berichten op de homepage te krijgen:

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);
}

maar zit nu met het probleem dat ik de naam van de genen die het laatste bericht gepost heeft der niet kan uithalen alleen de user_id

iemand een ideetje hoe ik de naam kan krijgen ?

tnx

[Paul]

Verander:

Code: Selecteer alles

$sql = "SELECT * FROM " . TOPICS_TABLE . " ORDER BY `topic_id` DESC LIMIT 0, 10"; 

om

Code: Selecteer alles

$sql = "SELECT * FROM " . TOPICS_TABLE . " t, ".USERS_TABLE." u  WHERE u.user_id = t.user_id ORDER BY `t.topic_id` DESC LIMIT 0, 10"; 

[Lucky Luke]

en dan is de username:

Code: Selecteer alles

$row['username']

dus in 1 geheel:

Code: Selecteer alles

$sql = "SELECT t.*, u.username 
           FROM " . TOPICS_TABLE . " t, ".USERS_TABLE." u
           WHERE u.user_id=t.topic_poster
           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],
     'username' => $row[username],
        '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);
}