PDA

View Full Version : min max statement.....HELP!!!


bkatsea
02-04-2010, 01:27 AM
Hello there,

Have successfully built my Realty search statement up to the part where I need am just needing the min and max values.

My fields are MinPrice and MaxPrice

This is it thus far,

SELECT busname, email,render_pic,area,logo,url,email,map,descripti on,tag,catch_phrase,region
FROM Results
WHERE STYLE LIKE 'varStyle' AND REGION LIKE 'varRegion' AND BEDROOMS LIKE 'varBedrooms' AND BATHROOMS LIKE 'varBathrooms'
ORDER BY ID desc

ANY HELP WOULD REEAALLY BE APPRECIATED!!! Have spent hours/days trying to resolve.

Tx in advance,

Brian

The search page can be viewed at www.dreamfinder.ca/default_master.asp (http://www.dreamfinder.ca/default_master.asp)

edbr
02-04-2010, 07:55 AM
you dont have those fields in your select statement

SELECT busname, email,render_pic,area,logo,url,email,map,descripti on,tag,catch_phrase,region

bkatsea
02-04-2010, 07:47 PM
Thank you for your reply!!

So have placed them in my select statement, but it doesn't seem to be "sorting" as per the search criteria of the minimum price range and maximum price range.

SELECT busname, email,render_pic,area,logo,url,email,map,descripti on,tag,catch_phrase,region,MinPrice,MaxPrice