Searching within a range - mySQL php

[richkoi]

I set up a database to have a searchable range of numbers. I have table set up that has an X column and a Y column. The X equals the low side of the range and the Y the high side.

How do I create a mySQL query that will search for one number within that range?

For example:

ITEM = Item 1
X = 3
Y = 5

ITEM = Item 2
X = 2
Y = 3

Search Variable = 4

Results: Item 1

Let me know if this is unclear. Thanks,

Rich

[JSeverson]

Hi,
Unless I'm misunderstanding your question, I think what you would want to do is this:

$result = mysql_query("SELECT ITEM FROM table WHERE X > $SearchVariable AND Y < $SearchVariable");

Hope that helps...

[Evic]

Actually JServerson, you were close - but got it backwards :)

$result = mysql_query("SELECT FROM table WHERE X < '" . $SearchVariable . "' AND Y > '" . $SearchVariable . "'");