Converting one value in array to UPPER case

[sharapov]

I am collecting data from the form. Before I put collected data That I got from $_POST['array']) into a MySQL database I want to convert one of the values (let's say value 1 in the array) in the array to upper case. How can it be done?

Below is the snippet of my code that I use to put data into a dtabase.

     $result=exequery("Select * from $tablename", $tablename, $dbname);
	 
	$flds = mysql_num_fields($result); 
	$qry=" "; 
    $query = "Insert into $tablename Values( "; 
	for ($x =0; $x < $flds; $x++){
	 	
            if(is_array($array[$x])){
            $mval=&quot;&quot;;
            for($m=0; $m < count($array[$x]); $m++){
                if($m+1 == count($array[$x])){
                    $mval.= AddSlashes($array[$x][$m]); 
               
                }else{
                    $mval.= AddSlashes($array[$x][$m]).&quot;,&quot;; 
                }
                $fval = $mval;
            }
        }else{
		    $fval = AddSlashes($array[$x]); 
        }
		$qry .= &quot;'$fval'&quot;; 
		if ($x < $flds-1){ 
			$qry.= &quot;, &quot;; 
		} 
	} 
	$query .= $qry.&quot;)&quot;; 

	$result=exequery($query, $tablename, $dbname); 
	if($result){ 
		return $result; 
	}else{ 
		return false; 
	}

 

[sleipnir214]

I'd use strtoupper() (

http://us4.php.net/manual/en/function.strtoupper.php),

ucfirst() (

http://us4.php.net/manual/en/function.ucfirst.php)

or ucwords() (

http://us4.php.net/manual/en/function.ucwords.php),

depending on how I need to capitalize the string.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[sharapov]

sleipnir214,

I understand the concept. What I can't figure out where to plug it in inside my code. Can you help?

Thanks.

 

[sleipnir214]

It's probably going to be inside an if-statement which checks for the appropriate column. I'd put the if-statement just inside the for loop.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[sharapov]

Thanks for the tip. I figured it out!