Select Statement

[eyedol]

I want to query the dabase base on search terms. This the code i used for the query

SELECT * FROM hotels WHERE hotels.Region LIKE '%$searchterm%' OR hotels.Rating LIKE '%$rating%' ORDER BY hotels.Rating Desc, hotels.Name Desc LIMIT 0, 10;

the search criteria will be passed from my php script as a variable.
I want users to search for hotels based on region or ratings or view all hotels and can also view hotels by ratings at particular region or the whole country. When i use sql statement up there, it only select everything in table hotels but not according to what i want to achieve.

Please is my sql statement wrong. Any help will be much appreciated. 🙂

[Norman_Graham]

Hi Eyedol

It would help if you specified what exactly is wrong with the results of your select statement. Your statement seems to be basically in order. One thing which might be causing a problem is the space after the comma in the LIMIT definition. It should be: LIMIT 0,10 and not LIMIT 0, 10.

Are you sure your variable names exactly match the variable names in your SELECT statement? Most of the problems I've ever had with SELECT statements have been caused by typing errors.

HTH

Norm

[eyedol]

It shows everything from the table. I want it to show information based on the Region or Rating the user will select.