Hi all,

I have the following columns in my table

ID | minwidth | maxwidth
1 | 1 | 145
2 | 146 | 220
3 | 25 | 100
4 | 101 | 140
5 | 30 | 39


I want to perform a query where I can find the row where my php POST formvariable 'width' is dynamic.

Example:
If 'width' = 10 only row 1 should be returned
If 'width' = 180 only row 2 should be returned
If 'width' = 105 only row 4 should be returned etc. etc.

Thanks for the help!

What SQL statements have you tried so far?

I only know the BETWEEN statement as a possible solution but that just works with one column and 2 (dynamic) values. At least, that's what I think now...

SELECT * FROM table WHERE minwidth BETWEEN formvariable_X AND formvariable_Y

I would like something as

SELECT * FROM table WHERE formvariable_X BETWEEN column_X AND column_Y

what happened when you tested this on your table?

Sometimes I feel really stupid...It works like a charm, probably made a typo error causing the errors...Thanks for bringing me back to life

Anyway solution is:

SELECT * FROM table WHERE formvariable BETWEEN column_x AND column_y

Sometimes the solutions stare you in the face. Good job!!