Found a bunch of bad code on site. Maybe because you are doing a backend review?

http://www.propertyinsantacruz.com/i...70/search.html

Partial of what I see on the customer page. Also think search may not be good?

# connected to host - 192.168.1.61
# connected to host - localhost
# SELECT * FROM users_searches WHERE id='170'
# MySQLImproved -> getRow -> SELECT * FROM users_searches WHERE id='170'
# MySQLImproved -> query -> SELECT COUNT(ListingID) AS total FROM properties_1 WHERE (CityID = '1' OR CityID = '8' OR CityID = '64') AND (class = '1') AND ListPrice >= 600000 AND ListPrice <= 800000
# MySQLImproved -> query -> SELECT `ListingID`,`class`,`ListPrice`,`ListingStatus`,`B eds`,`Baths`,`FilteredAddress`,`CityID`,`PostalCod e`,`LotSizeArea`,`LotSizeArea_Units`,`property_age `,`PublicRemarks`,`ListingID`,`ListOfficeName`,`Li stingOfficeID`,`ListAgentName`,`PhotoCount`,`State `,`stories`,`view`,`ListingAreaCode`,`amenities`,` BathroomFeatures`,`BedroomDescription`,`ExteriorFe atures`,`HasFireplaces`,`HasPool`,`FloorCovering`, `GarageParking`,`Levels`,`PropertyClass`,`LotSizeR ange`,`OtherAreas`,`PropertyClass`,`Roof`,`SewerSe ptic`,`Community_communityName`,`property_resource `,`cooling`,`heating`,`familyroom`,`formaldiningro om`,`property_energy_information`,`shower`,`shower tub`,`tub`,`yardgrounds`,`zoning`,`tractname`,`rev isiondate`,`crossstreet`,`associationfee`,`Structu reSize`,`modificationtimestamp` FROM properties_1 WHERE (CityID = '1' OR CityID = '8' OR CityID = '64') AND (class = '1') AND ListPrice >= 600000 AND ListPrice <= 800000 ORDER BY ListPrice DESC LIMIT 0,15
# SELECT name FROM metadata WHERE ref="Cities" && code='8'
# MySQLImproved -> getRow -> SELECT name FROM metadata WHERE ref="Cities" && code='8'
# MySQLImproved -> getQuery -> SELECT name FROM metadata WHERE ref = 'Areas' AND code = '44'
# SELECT name FROM metadata WHERE ref = 'Areas' AND code = '44'
# SELECT name FROM metadata WHERE ref="Cities

__________________
Santa Cruz Beach Homes|Capitola Real Estate| Aptos Beach Homes Santa Cruz is a vibrant community, located on the north end of Monterey Bay, and is home to artisans, beach goers, hi tech types, and college students. There is plenty of natural beauty from the ocean side coastal towns to the little mountain communities. Let my 30 years of local knowledge and 20 years of real estate help you find the right home or property in Santa Cruz.

Hi Gregg,

I've fixed this up.

__________________
Aaron
Programming Support
Real Estate Webmasters