Help with searching DB

Hello,

I need some help to search my database using a few variables.

I’m trying to search using a number between and a like option. I want to check the price between min and max and also where it’s held.

There’s a price field and a location in the database, there’s several different locations but all held under the same field name. Each product only has 1 location.

I tried...



This hasn’t worked. Could someone help out with the correct format of the query please?

The reason I’m using LIKE wildcard is cause the DB is holding location that says ’& surrounding’ at the end of some options.

Thanks.

what was it what didn’t work? The wrong result? mysql-error? or what?

Did you try:

Thanks Bruno,

I was just getting a null result and with your query it’s the same. If I remove the LIKE part of the statement it finds all within the price range so I wonder why the further search option isn’t working?

I just tried the LIKE part on its own and that worked but the 2 together won’t find results. ODD!

EDIT - Sorry Bruno... Got it working. I had a small mistake in the rest of my statement. Thanks a lot!