set_charset('utf8');
$erg = $db->query("SELECT usr_id,
CONCAT(id3.usd_value, id4.usd_value) AS Ablage, id2.usd_value AS Titel, IFNULL(id6.usd_value,id5.usd_value) as Ersteller
FROM adm_roles, adm_categories, adm_members, adm_users
LEFT JOIN adm_user_data id2 ON id2.usd_usr_id = usr_id
AND id2.usd_usf_id = 2
LEFT JOIN adm_user_data id3 ON id3.usd_usr_id = usr_id
AND id3.usd_usf_id = 165
LEFT JOIN adm_user_data id4 ON id4.usd_usr_id = usr_id
AND id4.usd_usf_id = 166
LEFT JOIN adm_user_data id5 ON id5.usd_usr_id = usr_id
AND id5.usd_usf_id = 168
LEFT JOIN adm_user_data id6 ON id6.usd_usr_id = usr_id
AND id6.usd_usf_id = 187
WHERE cat_org_id =2 AND mem_begin <= NOW() AND mem_end > NOW()
AND id3.usd_value IS NOT NULL
AND rol_valid = 1
AND rol_cat_id = cat_id
AND mem_rol_id = rol_id
AND mem_usr_id = usr_id
AND usr_valid = 1
Group BY id2.usd_value
HAVING COUNT(*) > 1
ORDER BY Titel ASC;");
while ($zeile = $erg->fetch_object()) {
Switch ($i){
case 25:
Echo 'nach oben';
$i=0;
break ;
default:
$i++;
break;
}
?>
Ablage;?>
Titel;?>
Ersteller;?>
free();
$db->close();
?>
nach oben