Inserting Capitalized values

[chefmars]

Below are part of the query that collects/processes the submitted form variable values.( the actual form collects and process about 20 variables)

$query = $query . "'$firstname',";
$query = $query . "'$phone',";
$query = $query . "'$occupation',";

$query = $query . "'$employer',";

Below is the "meat of the query" that is inserted into the mysql DB using PHP.

$link = sql_pconnect($DBServer, $DBLogin, $DBPassword);

$result = mysql_query("INSERT INTO Visitors VALUES($query)", $link);

QUESTION: How do I make sure that the INSERTED occupation and employer values are all capitalized, that is all the strings or words inside each field are capitalized no matter how the user inputs them in the form--AND also that the firstname field is completely in capital letters.

[NameNick]

chefmars,

The functions [man]strtoupper/man, [man]strtolower/man and [man]ucfirst/man do that job. You can upper or lower all or onyl the first character.

Hope that helps.

NN