Suche:
PHP-Code:
$userliste = db_query("SELECT k.uid,k.status,k.kontostand,u.nickname,u.vorname,u.angemeldet_seit,e.emailadresse
FROM ".$db_prefix."_kontodaten AS k
LEFT JOIN ".$db_prefix."_userdaten AS u ON u.uid=k.uid
LEFT JOIN ".$db_prefix."_emaildaten AS e ON e.uid=k.uid
ORDER BY k.uid ASC");
Ersetzen mit
PHP-Code:
$userliste = db_query("SELECT k.uid,k.status,k.kontostand,u.nickname,u.vorname,u.angemeldet_seit,e.emailadresse
FROM ".$db_prefix."_kontodaten AS k
LEFT JOIN ".$db_prefix."_userdaten AS u ON u.uid=k.uid
LEFT JOIN ".$db_prefix."_emaildaten AS e ON e.uid=k.uid
ORDER BY u.nickname ASC");