Where $val between col1 and col2?

**biglittle** · Jan 28, 2013 09:39

Is this a valid statement? "SELECT * FROM Table WHERE '$Value' BETWEEN Column1 AND Column2", with the columns as doubles?

**r937** · Jan 28, 2013 09:52

Originally Posted by biglittle

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

**K. Wolfe** · Jan 28, 2013 10:03

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

**r937** · Jan 28, 2013 10:32

Originally Posted by K. Wolfe

Perhaps you should provide the actual PHP code ...

in the php forum, eh

**biglittle** · Jan 28, 2013 10:39

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

Thanks for the replies everyone!

User Tag List