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));

• make lower case
• make lowercase into uppercase
• mysql_query set lowercase
• virtuemart userfields capitalize
• uppercase when followed by uppercase
• uppercase letter data
• virtuemart user field uppercase
• ubuntu make lowercase
• query to change the lowercase data to uppercase
• php valid uppercase lowercase name
• freakholicz
• making lower case to upper case
• make lowercase
• make followed by
• make field lowercase
• how to make field lowercase
• freebsd make uppercase lowercase
• why is the i lowercase in in demand