nicht nur das, da war auch nen anderer fehler noch drin,
dass passiert wenn man alles per copy and paste macht,
nur damit man paar zeichen schreiben spart.
der obere und der untere code sind gleich,
das sollte aber so nicht sein.
hier der richtige code:
[qcode]
// show next and previous profile link
$sql ="SELECT ".get_user_table_field("u.","user_id").get_user_table_field(",u.","user_name")."
FROM ".USERS_TABLE." u
LEFT JOIN ".GROUP_MATCH_TABLE." m ON (".get_user_table_field("u.","user_id")." = m.user_id)
WHERE ".get_user_table_field("u.","user_id")." > $user_id AND m.group_id = 1
ORDER BY ".get_user_table_field("","user_id")." ASC
LIMIT 0,1";
$result_profile_next = $site_db->query_firstrow($sql);
$sql ="SELECT ".get_user_table_field("u.","user_id").get_user_table_field(",u.","user_name")."
FROM ".USERS_TABLE." u
LEFT JOIN ".GROUP_MATCH_TABLE." m ON (".get_user_table_field("u.","user_id")." = m.user_id)
WHERE ".get_user_table_field("u.","user_id")." < $user_id AND m.group_id = 1
ORDER BY ".get_user_table_field("","user_id")." DESC
LIMIT 0,1";
$result_profile_previous = $site_db->query_firstrow($sql);
$profile_next_userid = (isset($result_profile_next[$user_table_fields['user_id']]) && $result_profile_next[$user_table_fields['user_id']]> GUEST) ? $result_profile_next[$user_table_fields['user_id']] : 0;
$profile_previous_userid = (isset($result_profile_previous[$user_table_fields['user_id']]) && $result_profile_previous[$user_table_fields['user_id']]> GUEST) ? $result_profile_previous[$user_table_fields['user_id']] : 0;
$site_template->register_vars(array(
"profile_next_link" => ($profile_next_userid) ? "<a href=\"".$site_sess->url(ROOT_PATH."profile.php?action=showprofile&".URL_USER_ID."=".$profile_next_userid)."\">Next Profile</a>" : "",
"profile_previous_link" => ($profile_previous_userid) ? "<a href=\"".$site_sess->url(ROOT_PATH."profile.php?action=showprofile&".URL_USER_ID."=".$profile_previous_userid)."\">Previous Profile</a>" : "",
));
// show next and previous profile link[/qcode]
siehe rotes "<"