Make all database rows lowercase with a capital

[eits]

Hello!

 

I was wondering if it is possible to do the following with a PHP script (I am new to PHP). I have a database with customer information but all the company names are in capitals. Is it easy to somehow convert all of these to lowercase but with a capitalised letter for the first letter of each word.

 

so 'BOBBYS BITS AND PIECES'

 

becomes 'Bobbys Bits And Pieces'.

 

Thanks in advance!

 

[MadTechie]

use ucfirst

ucfirst(strtolower("BOBBYS BITS AND PIECES")); 

[xyn]

a capitalised letter for the first letter of each word.

so 'BOBBYS BITS AND PIECES'

becomes 'Bobbys Bits And Pieces'.

 

close.. but ucwords("BOBBYS BITS AND PIECES");

[eits]

Great - thats something I havent stumbled across yet!

 

How would I make it replace all of the MySql entries at once though?

[MadTechie]

no SQL statements to update them with that!..

your need to create a script that loop throught each record and update it.

 

basic idea

1. connection #1, select *

2. loop though each records (start)

3. $data = ucwords(strtolower($c1row['data']));

4. connection #2 update table set data='$data' where ID={$c1row['id']}

5. end loop

 

 

sorry (i'm at work so had to be quick )