[Resolved] formatting string

[bampot]

I'm working with a mysql database and i have product descriptions which i want to display, in the database all the description are in uppercase yet i would prefer to have the output as ucfirst() or ucwords(). At the mo i can only get strtolower() to format the string. Is there an sql query i can run to reformat to lowercase then use ucfirst().

I hope you can understand by babblings = )

thanks in advance

[The_Chancer]

Update table set string='".ucfirst(strtolower($text))."''

Something like that....

[bampot]

thanks for that

couldnt run it on the database, but i was able to format the output

[The_Chancer]

That was to be run like so...

<?
$query=mysql_query("SELECT * from `table`");
while($stuff=mysql_fetch_assoc($query))
{
   $query2=mysql_query("update `table` SET text='".ucfirst(strtolower($stuff['text']))."' WHERE id='".$stuff['id']."'");
}
?>

[bampot]

ahaa

it all makes sense now

thanking you kindly