[Resolved] search and change

raouleduke

I have a field in my database that has severall opcodes like this
3F YSUSP 99P GTIRE 37C I am looking for certain opcodes in this field and want to translate them into text. Like YSUSP would print out suspension. I have the Select down fine

WHERE (OPCODE LIKE '%YLEAK%' OR OPCODE LIKE '%YCV%' OR OPCODE LIKE '%YEXH%' OR OPCODE LIKE '%YTRANS%' OR OPCODE LIKE '%YSTEER%' OR OPCODE LIKE '%YSUSP%' OR OPCODE LIKE '%YBRAKE%' OR OPCODE LIKE '%YCOOL%')

when I print out the results I get five records I want to translate the OPCODE's, wether it be one or eight, to text.

Any ideas ??

Thanks,

Shrike

Use an array which contains the translations, or even a database table.

$row['opcode'] = "YSUSP YTRANS";
$codes = explode(" ", $row['opcode']);
$translate = array("YSUSP" => "Suspension", "YTRANS" => "Transmission");
foreach($codes as $code){
  echo $translate[$code]." "; // echoes Suspension Transmission
}

By the way, if you are storing more than one code in a database cell, your database schema probably needs a rethink. I would create a new table, which has each type as a column, and also an id field to link to a product (presumably a car?)

raouleduke

Thanks so much, that is the only way I can get the data, but yeah if I had my choice they would be in different fields. Is there a way that I can just print out one of the translations which ever comes first and if there is none of the translations print out a blank expanation.

$codes = explode(" ", $row1['OPCODE']); 
	$translate = array("RBK" => "URL", "YBK" => "URL", "GBK" => "URL"); 
	foreach($codes as $code){ 
  	echo $translate[$code]." "; // echoes Suspension Transmission 
	}

Shrike

$codes = explode(" ", $row1['OPCODE']);  

$translate = array("RBK" => "URL", "YBK" => "URL", "GBK" => "URL");
$found = null;
foreach($codes as $code){  

  if(array_key_exists($code, $translate)){
    $found = 1;
    echo $translate[$code]." ";
    break;
  }else{
    continue;
  }
}
if(!$found) echo "Not found";

raouleduke

That solved my more than one entry, but if there is nothing in there to translate, I want to display a blank URL. Like if there is no RBK, YBK or GBK , I want to display blank URL.

raouleduke

Did you repost something, I think that I grabbed the first one.

Anyway it works, thank you so much.

Shrike

Yes I changed it about 1 minute after posting, you must have quick fingers 😉