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?

Quote:

---

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

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

Quote:

---

Originally Posted by K. Wolfe

Perhaps you should provide the actual PHP code ...

---

in the php forum, eh ;)

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

Thanks for the replies everyone!