|||||||| Case Neutral if statement ???

Gary_Kambic

Hello,

I have a large table with names in upper and lower case. I would like to enter a name ($name) in any case and check it against the table name ($name_table). Currently, I have to type "Gary Kambic" to get a positive match against "Gary Kambic". I would like to be able to type "gary kambic" and get the same match.

How do I do this?

Thanks, Gary

while ($i < $num) {
$name_table = mysql_result($result,$i,"agent_name");

if ($name_table == $name) {
$status = "yes";
$i2 = $i;
$i = $num; }
else
++$i;
}

juschillinnow

change both the search and the value string to upper case using:

strtoupper and then check them.

hi-liter

or check these out for solutions:

http://phpbuilder.com/board/showthread.php?s=&threadid=10238808

http://phpbuilder.com/board/showthread.php?s=&threadid=10238752&highlight=case+sensitive

trooper

why not make all your names lowercase when yo uput them into the database using the SQL function LOWER

Then you know that all the names are the same (in terms of capitalisation)

Gary_Kambic

Thanks everyone,

I just converted both variable strings using the strtolower command and then checked them. It worked very well.

Gary