Where $val between col1 and col2?

Is this a valid statement? “SELECT * FROM Table WHERE ‘$Value’ BETWEEN Column1 AND Column2”, with the columns as doubles?

the quotes are unnecessary, since DOUBLE is not a string datatype

otherwise, it looks fine

Perhaps you should provide the actual PHP code if you are having any problems with it so that we can help you out.

in the php forum, eh :wink:

I got it working; I just had a typo in my variable :S

Thanks for the replies everyone!