Code to search for part of form input

[Anon]

Searching a zipcode field. If the person enters a five digit zip code in the search field of my form, i.e. 12345 I want the search to find all records in my database where the zip code field starts with 123

Ingoring the remaining two numbers.

I am using this code to search:

$query= mysql_query("SELECT * FROM 99MC WHERE ZIP='$search_query' ORDER BY LASTNAME");

But I'm lost...

Thanks for any help

Dan

[btubalinal]

$zip_code = "12345";
$first_three_chars = substr($zip_code, 0, 3);
$zip_code_to_search = $first_three_chars . '%';

$query = "SELECT * FROM 99MC WHERE ZIP='$zip_code_to_search' ORDER BY LASTNAME"

//Connect to db first
.....

//run query
$result = mysql_query($query);

//Do rest of processing
.......

BT

[Anon]

Thanks for your help. Gave what I needed to get there.

However, I couldn't get it to work until I changed your:

WHERE ZIP='$zip_code_to_search'

to

WHERE ZIP LIKE'$zip_code_to_search'