Nazdarek. Robim si na stranke formular pre vyber uzivatelov s galeriou/bez galerie. No mam taky problem. Neviem ako spravit aby mi vybralo uzivatelov BEZ Galerie.
Totiz v tabulke
register mam ulozene
ID, meno atd. a v tabulke
galery mam
Id_uzivatela, ktore je zhodne s ID z tabulky register.
Pri vybere uzivatelov s galeriou mam takyto select:
Kód:
$query="select register.meno, galery.nazov_albumu, galery.id_albumu, galery.datum, galery.cas from galery join (select id_uzivatela, max(cas) as cas
from galery group by id_uzivatela) as nejvyssi on galery.id_uzivatela = nejvyssi.id_uzivatela and galery.cas = nejvyssi.cas
left join register on galery.id_uzivatela = register.id $orderby";
Pri vybere vsetkych uzivatelov(tzn s galeriou a bez) takyto:
Kód:
$query="select register.meno, galery.nazov_albumu, galery.id_albumu, galery.datum, galery.cas from galery join (select id_uzivatela, max(cas) as cas
from galery group by id_uzivatela) as nejvyssi on galery.id_uzivatela = nejvyssi.id_uzivatela and galery.cas = nejvyssi.cas
right join register on galery.id_uzivatela = register.id $orderby";
No neviem prist na to ako urobit select alebo podmienku aby mi vybralo ciste len uzivatelov bez galerie tzn. v podstate uzivatelov z Register, ktori nie su v Galeri.
Uz som skusal rozne moznosti, ale fakt mi uz dochadzaju napady.. Neviete mi niekto poradit/ pomoct??