Page 1 of 1

Help with SQL query

Posted: Tue Feb 07, 2006 3:40 pm
by ddragas
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());

Posted: Tue Feb 07, 2006 3:52 pm
by pickle
Moved from PHP Code to Databases...

What error do you get? Does your version of MySQL support subqueries?

Posted: Tue Feb 07, 2006 3:58 pm
by ddragas
pickle wrote:Moved from PHP Code to Databases...

What error do you get? Does your version of MySQL support subqueries?
right now I've been reading topic that asked the same question

MySQL Servers and Clients 3.23.47

Posted: Tue Feb 07, 2006 4:01 pm
by ddragas
error is

Code: Select all

You have an error in your SQL syntax near 'select smjestaj from banner where ((prikazivati_do <= '1139349957') or ' at line 5

Posted: Tue Feb 07, 2006 4:06 pm
by feyd
Subqueries were added in 4.1 I believe.. so you can't use them.

Posted: Tue Feb 07, 2006 4:07 pm
by ddragas
I've also found answer on some post.

Thank you both for reply

Posted: Tue Feb 07, 2006 4:10 pm
by Weirdan
Depending on the mysql version, it could be that subqueries were not supported...