';
if(!@$show) $show="all";
if(!@$order) $order="prijmeni";
if($show!="all")
{
echo 'Seznam uživatelů (pouze aktivní):zobrazit vše';
$where="WHERE active IN (1) ";
}
else
{
echo 'Seznam všech uživatelů:zobrazit pouze aktivní';
$where="WHERE active IN (0,1) ";
}
#$string=MySQL_Query("SELECT c.id as cid, (SELECT i.ip FROM ipecka i, adresy a WHERE i.adresa=a.id AND a.clen=c.id LIMIT 1) as cip, c.*
# FROM cleni c
# $where ORDER BY $order");
$string=MySQL_Query("SELECT c.id as cid, c.*, a.id as aid, a.*, i.id as iid, i.*
FROM (cleni c LEFT JOIN adresy a ON c.id = a.clen )
LEFT JOIN ipecka i ON c.id = i.clen AND a.id = i.adresa $where GROUP BY c.id ORDER BY $order" );
echo '
Celkem zobrazeno '.$celkem.' záznamů.
';
?>