PHP/MySQL select from with multiple WHERE and ranges

Question

Here is exactly what I would like to do (step by step in the order it makes sense to me)

Is this possible? Not really looking to get it handed to me, more looking for a starting point to search.

Ofir Baruch · Accepted Answer · 2012-08-25 21:01:26Z

2

BETWEEN is your answer.

SELECT * FROM table WHERE x BETWEEN $x-6 AND $x+6 AND y BETWEEN $y-6 AND $y+6

Put in a mysqli_query (or use PDO) and fetch the results.

answered Aug 25, 2012 at 21:01

Ofir Baruch

10.3k2 gold badges29 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thank you very much, this has helped out a ton!

Anant Dabhi · Accepted Answer · 2012-08-25 21:03:12Z

0

you can only one where clause in one select statement

but you can you multiple comparator like

select * from table where (col1=10 and column2>25)  or col3=10

for your above query it

select * from table where (x>-6 and x<6) and  (x>-6 and x<6)

answered Aug 25, 2012 at 21:03

Anant Dabhi

11.2k3 gold badges33 silver badges51 bronze badges

khaverim · Accepted Answer · 2012-08-25 21:03:47Z

0

SELECT * FROM table
WHERE x >= $x - 6 AND x <= $x + 6
AND y >= $y - 6 AND y <= $y + 6

Then use PHP's functions to fetch_array on the query

answered Aug 25, 2012 at 21:03

khaverim

3,5846 gold badges38 silver badges48 bronze badges