searching for zipcode: where to start?
| From: | dean james | Date: | Sun, 11 Nov 2001 00:27:59 +0000 |
| Subject: | searching for zipcode: where to start? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14222@lists.php.net to get a copy of this message | ||
hello,
I want to create a database search with php/mysql that searches for zipcodes in a database. of course, there will be other columns/tables and such to be printed, but I only want to search for the zipcodes and have the other cells printed if the following criteria are found:
lets say I search for the zipcode 90232...it would return like so....
1. search returns 3 closest matches
John Doe
90232
Red Corvette
Mary Jones
90235
Silver Camaro
Peter Gooding
90065
Blue Honda
et.... -> the search will generate only "3" returns...either 3 exact matches, in this case 90232 or (1, or 2) and the closest....Basically the search will ALWAYS return 3 results, either exact matches or closest matches..any combination......so every entry in the database is a potential match...just the 3 closest
what is the best way to go about doing this?
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp