full-text index that field in MySQL, - then query ordered by weight with
a limit 3. Wonderful stuff.
From: dean james
Sent: Sat 11/10/2001 7:27 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] searching for zipcode: where to start?
I want to create a database search with php/mysql that searches
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
printed if the following criteria are found:
lets say I search for the zipcode 90232...it would return like
1. search returns 3 closest matches
et.... -> the search will generate only "3" returns...either 3
matches, in this case 90232 or (1, or 2) and the
search will ALWAYS return 3 results, either exact matches or
matches..any combination......so every entry in the database is
match...just the 3 closest
what is the best way to go about doing this?
Get your FREE download of MSN Explorer at
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: