Where $val between col1 and col2?

Databases
1

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

2

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

otherwise, it looks fine

3

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

4

in the php forum, eh :wink:

5

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

Thanks for the replies everyone!