If the field has a value of 0, that means it is blue.
1=yellow
2=green
3=black
etc
From a development standpoint, is it better to have a method that converts them
ie
Code: Select all
if($color == 1)
$returnval = "yellow";
if($color == 2)
$returnval = "green";
return $returnval;I'm inclined to think it's better to have a table with 2 columns (code and color), then you can make a UI so users can add/modify/delete colors, but I'm wondering if there's an industry standard. Thanks in advance