Help with SQL query
Posted: Tue Feb 07, 2006 3:40 pm
Why doesn't this work?
Code: Select all
$result = mysql_query("select Sifra_apartmana from apartmani
where apartmani.iznajmljivac = '$broj'
and Sifra_apartmana NOT in
(
select smjestaj from banner
where ((prikazivati_do <= '$danas') or
(banner.prikazivati >= banner.prikazano))
)
order by apartmani.vrsta_smjestaja ") or die (mysql_error());