..having difficulty understanding how to select all records from MySQL within a range of two criteria.
In other words, my form has two pull-down lists of items.
List one - 1-13 items
List two - the same 1-13 items
Let's say we choose item 2 in list one, and item 5 in list two.
How do I query the database to echo all records in the range between 2 and 5 inclusive, i.e. 2,3,4,5 ?
thanks
In other words, my form has two pull-down lists of items.
List one - 1-13 items
List two - the same 1-13 items
Let's say we choose item 2 in list one, and item 5 in list two.
How do I query the database to echo all records in the range between 2 and 5 inclusive, i.e. 2,3,4,5 ?
thanks