Array depending on if

[raffael3d]

I have this array

now I want to make depending on which number is in the database it should echo that
something like this.

$rd = mysql_query("select catg from intern where id=$update"); 

$catg = array(1 => 'car', 2 => 'intern', 3 => 'Tarif');

but so far it shows all the three options. but I want that it shows only the one that is in the data. e.g in the databas is the number "1"
so I want to echo "car".
how can I do that?

[devinemke]

extract (mysql_fetch_assoc (mysql_query ("SELECT catg FROM intern WHERE id = $update")));
$catg = array (1 => 'car', 2 => 'intern', 3 => 'Tarif');
echo $catg[$catg];

[devinemke]

whoops, try this:

extract (mysql_fetch_assoc (mysql_query ("SELECT catg FROM intern WHERE id = $update")));
$catg_array = array (1 => 'car', 2 => 'intern', 3 => 'Tarif');
echo $catg_array[$catg];

i'm still not quite sure what you mean. the above code will echo "car" if the varibale $catg from the database equals 1.

[raffael3d]

it should echo the word for the value.

so if the value is 1 it should echo the word in the array that stands for one
if it's 2 it should echo word 2
see?

[devinemke]

then the code i posted will do that assuming the value of "catg" coming from the database is the number 1-3. If not you will get an undfined index error.