storing db variables to other variables

riffy

Hi all,

I have a page which extracts values from a database and displays them on the screen. However in the database they are entered as numbers and I want to assign the numbers, text values before they are displayed.

There are 4 numbers: 1,2,3,4

1 is fully disagree, 2 is partially disagree, 3 is partially agree, and 4 is fully agree.

After extracting those values how do I assign them to newer values?

Arif

sglane

The best way to do it is to create a translate table but the quick and dirty way to do it is:

switch ($i) {
   case 1:
      $i = "fully disagree";
   case 2:
      $i = "partially disagree";
   case 3:
      $i = "partially agree";
   case 4:
      $i = "fully agree";
}

Hope this helps.

riffy

thanks alot sglane however i forgot to mention one little, but most important thing.

the form that i'm submitting into the database has about 27 questions, each of which has 4 answer questions in the form of radio buttons...the name of each set of 4 radio buttons corresponds with the question number...so the name for the first set of 4 radio buttons is question1 and the value is 1,2,3,4 depending on which button the user clicked..

the value is stored in the database as question1='1', question2='3', question3='4' and so on...

i guess my question is how do i get the value of each variable and THEN set that number to text?

i dunno how to go about it...do i have to set up some sort of an array?

thanks
arif

sglane

An array is another good way to go.

$text_values[1] = "fully disagree";
$text_values[2] = "partially disagree";
$text_values[3] = "partially agree";
$text_values[4] = "fully agree";

echo "question 10's answer was : " . $text_value[$question10];

That should do it.

riffy

thanks sglane for all your help...this is something i will definitely remember for future use

😃