Searching for multiple cases of a string

ztron

I'm creating some admin tools for a site to search for various things such as state, zip, e-mail, id number and print results according to the input. Right now it is working fine, but the database that it's pulling the info from has some states that are uppercase, lowercase, and mixed. I want to be able to type in say "PA" and have it return all the info with states that are "pa", "Pa", or "PA"
Any variations of case. Right now it will only pull what you type in and this is the code I am using:

if(!empty($_POST["s_state"]))
        {
         echo "State Search for <b>" . $_POST['s_state'] . "</b>:<BR>";
         $temp_state = str_replace(" ", "", trim($_POST["s_state"]));
         $query = "Select dm_id, dm_first_name, dm_last_name, dm_phone from distributor_main where dm_state LIKE '$temp_state%'";
         display_invoice_search_results($query);
         }

Any help is appreciated.

LordShryku

/* convert search to uppercase */
$temp_state = strtoupper(str_replace(" ", "", trim($_POST["s_state"]))); 
$query = "SELECT dm_id, 
                 dm_first_name, 
                 dm_last_name, 
                 dm_phone 
          FROM   distributor_main 
          WHERE  UPPER(dm_state) = '".$temp_state."'";

ztron

that's what i thought. i just wasn't exactly sure where to place the strtoupper function. will this make it so all of the data whether pa or Pa is all uppercase? or will it just make it so that what they type in to search for is converted to uppercase?

i really need something that will return multiple cases since the database is messed up. like have it search for multiple cases in one search. i'll try this out. if that's what it does, thanks!

i'm new to the language and don't really know any of the functions or how they work. just been reading a lot and trying to gain knowledge. it's like c on steroids!

LordShryku

the strtoupper converts it to upper case.
the WHERE UPPER(dm_state) in your sql query converts the search to an upper case search

ztron

that's exactly what i wanted. thank you very much for the help.