Format Database Text

[digital_skwerl]

I have a table of US cities, states, zips, lat, long, etc. About 43,000 records.

All text in the table is CAPITALIZED and I want to format first letter caps and the remaining lower case so that I don't need to do it every time I pull and display a record on the site.

I originally wrote a php script making use of

ucwords(strtolower($string))

to select a record, edit the text format, run an update query, loop to next record.

Problem is it can only update about 250 records before timing out. Is there any way to change db text style using mysql alone? Is there a better (faster) way to do this with php?

Any help appreciated as always.

[zingbats]

You can set the time out of PHP by doing this:

set_time_limit(1000000);

Which will set the timeout to about a 11 days

[digital_skwerl]

Thanks zingbats. For anyone else, check out set_time_limit in the manual. I'll post some final code too when I get a chance.