Multiple like results from query?

[xavior]

I am trying to query the database for zip codes and get multiple results even though the zip code is specific. I can get multiple results if I don't enter the full zip code but I need them to enter the full code.

Example:
I query the database for zip code 80537. When submitted I need it to show all zip codes starting with the first 3 digits (805).

[Tracer]

Create a new string from the posted user entry...

$user_entered_zip

//modify your data for only first three strings and output
//your new $zip

SELECT x from x WHERE zip LIKE '$zip%'

Use the % as the wildcard in your mysql select