Using MySQL sub queries in PHP CLI

[milanmk]

I am using a sub query like the following in a cron file and its throwing a query error.

...eexpiry = (CURDATE() + INTERVAL (SELECT alert2 FROM settings) DAY)...

Does that mean I cant use sub queries in PHP CLI?

Milan

[jatar_k]

what is the exact error it gives you?

have you tried the query you are trying to run from the command line?

[milanmk]

The error shown is:-

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT alert2 FROM settings ) DAY )

I cant try it on CLI on server as its a shared hosting environment. I have a testing setup on Windows at my place where i will try it and let you know.

Milan

[milanmk]

Oh my host uses MySQL version 4.0.27-standard and sub queries are only supported from 4.1 onwards!

Milan

[jatar_k]

that would definitely do it