Nye postinger funker ikke

[Lindsay]

Hvorfor funker ikke denne ?

 

$sql_ary = array(

'SELECT' => 'MAX(p.post_time) as post_time, u.user_id, u.username, u.user_colour, t.topic_title, t.forum_id, t.topic_last_post_id',

'FROM' => array(TOPICS_TABLE => 't', POSTS_TABLE => 'p'),

'LEFT_JOIN' => array(

array(

'FROM' => array(USERS_TABLE => 'u'),

'ON' => 't.topic_last_poster_id = u.user_id',

),

),

'WHERE' => 'p.topic_id = t.topic_id

AND p.post_approved = 1

AND t.topic_moved_id = 0' . $sql_and,

'GROUP_BY' => 't.topic_id',

'ORDER_BY' => 'post_time DESC',

);

 

$result = $db->sql_query_limit($db->sql_build_query('SELECT', $sql_ary), 10);

 

while( $row = $db->sql_fetchrow($result) )

{

 

$view_topic_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&p=' . $row['topic_last_post_id'] . '#p' . $row['topic_last_post_id']);

$topic_title = censor_text($row['topic_title']);

 

$template->assign_block_vars('top_five_topic',array(

'U_TOPIC' => $view_topic_url,

'USERNAME_FULL' => $user->lang['BY'] . ' ' . get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']),

'TOPIC_TITLE' => $user->lang['IN'] . ' ' . $topic_title));

}

 

$db->sql_freeresult($result);

 

Det virker som den ikke mottar info fra databasen

[MikkelRev]

echo $sql_ary;

Se om spørringen fortsatt ser bra ut etter at den er generert.