[SOLVED] capitalizing the first letter in a MySQL output

[webguync]

Hi,

 

I am outputting information in a MySQL table and I wanted if possible to make sure the initial letter in the first and last names appears capitalized. Currrently some are and some aren't.

 

Here is the code to extract the info:

 

echo "<td>" . $row['employee_name'] . "</td>";

 

 

 

 

[benphp]

ucwords($row['employee_name']);

[premiso]

Alternatively you can do this in MySQL:

 

SELECT UCASE(LOWER(`employee_name`)) FROM TABLE_NAME WHERE Condition=otherCondition

[webguync]

cool, thanks!