sql sub array!?

[Dave]

Code: Alles auswählen

$sql = "SELECT u.username, u.user_id, u.user_level, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_gott, u.user_halbgott, u.user_warnings, u.user_color, u.avatar_remote_width, u.avatar_remote_height, u.user_stamm, ". $sql_game_data . " p.*,  pt.post_text, pt.post_subject, pt.bbcode_uid, g.*
	FROM " . POSTS_TABLE . " p, " . USERS_TABLE . " u, " . POSTS_TEXT_TABLE . " pt LEFT JOIN " . USERS_GAME_TABLE . " g ON g.user_id = p.poster_id
	WHERE p.topic_id = $topic_id
		$limit_posts_time
		AND pt.post_id = p.post_id
		AND u.user_id = p.poster_id
	ORDER BY p.post_time $post_time_order
	LIMIT $start, ".$board_config['posts_per_page'];
//-- mod : categories hierarchy ------------------------------------------------
//-- add
$sql = str_replace('SELECT ', 'SELECT pt.post_sub_title, ', $sql);
//-- fin mod : categories hierarchy --------------------------------------------
if ( !($result = $db->sql_query($sql)) )
{
	message_die(GENERAL_ERROR, "Could not obtain post/user information.", '', __LINE__, __FILE__, $sql);
}

Diese Abfrage habe ich in der viewtopic.php
Nun habe ich das Problem das in der USERS_GAME_TABLE mehr als nur ein eintrag ist. wie komme ich an ALLE Ergebnisse?


MfG
Dave

[Dave]

~closed~