Am i on the right track???

[JAPH]

here is what I am attempting:

in a mysql database, i have two fields (priority and status) where I enter numbers.

In the php script to display the data, i want it to interpret the numbers to their meanings (e.g 0=not high, 4=high, 5=cancelled, etc.)

am i correct in assuming that i should make a function, put the numbers into an array and have the function interpret that? does this make sense? it's confusing me.....

because i can't just say if 0 spit out not high, becayse the numbers for priority and status have different meanings......

[barand]

Create 2 tables, priority and status. In each, create a record for each code with meaning in a second field. Set the code fields as primary keys.

This lets you edit the meanings or add further codes at a later date without having to touch a line of code.