Question :

I have table A with field id, name and address. The data in name field seem not consistent, big letter name sometime found in record. How to update that field with uppercase in name field. For example :

                 id              name                                       address

                 1               FreAKHolicz  wORker            the moon

                 2              tHE atMOSFER bluEZ            nowhere

FreAKHolicz  wORker must change to Freakholicz Worker

Answers :

1. Looping

2. Use strtolower() function followed by ucwords() function.

example code :

<?

$query=mysql_query("select id,name from table A");

while(list($id,$name)=mysql_fetch_row($query))

{

//change to lower case

$name1=strtolower($name); // will make FreAKHolicz  wORker  into freakholicz worker

//change to uppercase

$name2=ucwords($name1); // will make freakholicz worker into Freakholicz  Worker

//now using $name2 as variable to update name field

$update=mysql_query("update A set name=’$name2′ where id=’$id’");

}

?>

since it’s looping, all good record also examined by scripts until no record left, using another conditional condition would bring another result.

P.S :

• Use ucfirst() to change only first alfabet
• Its possible using many function in one operation such as :  $name2=ucwords(strtolower($name));