I am in the process of creating a Real estate web site and it needs to have a search able database. I am trying to have someone select an option from a menu, then hit search and restrict the results based on the URL variables. I know how to use $GET [id] and I have been trying the same for the search options, with no luck as of yet.
$query_rs_listings = "SELECT listings.Id, listings.town, listings.mkt_area, listings.list_price, listings.address, listings.ml, listings.list_office, listings.list_office_phone, listings.property_type, listings.baths, listings.bedrooms, listings.square_feet, listings.acreage FROM listings WHERE listings.property_type= $_GET[property_type]";
What am I doing wrong?? I always receive an error message after I hit submit on the search page:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 10' at line 1
so I know its something wrong in the recordset. If anyone has encountered this or can help, it would be greatly appreciated.