PROJECT:? Display Used CarInventory Quickly by Price Only.
SITUATION:? ? [login to view URL] hosts adatabase of hundreds of thousands of used cars for sale. The database isupdated daily.
Today, visitors can search for used cars by selecting aMake, Model, Year, Maximum price, within X miles of a Zip Code. (See <[login to view URL]>)for an example. This narrows down the database so that results are displayedquickly.
PROBLEM:? We are able, using MySQL,to allow visitors to search for any car using only Price as the searchcriteria. However, it takes too long to display the results so we do not offerthis option.
SUCCESSFUL EXAMPLE:? ? Look at [login to view URL]’sused car search capability (<[login to view URL]>).Enter a zip code (required) but do not select a Vehicle Make or Vehicle [login to view URL] on Search and you will be taken to a results page.
Using the zip code: 90210 returns 1 of more than 2,000 pagesof results in only a few seconds ([login to view URL]).? From this page, you can refine the results bymany different parameters.
SOLUTION:? ? Develop a MySQL querythat will allow us to display used cars from our inventory using only Zip Code,Distance from Zip Code and Price as the search criteria.
?
?
?