Change values to text

[paulocoré]

Hi there.

I'm trying to know how to change the values to a text, i'm coding one administrator panel, i've made one table called logs, and there will be a lot of columns one of them is called Rank, everytime users change the rank to Administrator at column Rank it will be 1, cant it be Administrator?

[alemcherry]

Only you can answer it. This is your logic, you are the one interpreting the data in database to rights of users. I don't want to be harsh, but if you are asking such questions on a public forum, probably you are not qualified to do custom coding in PHP.

[paulocoré]

That answer had no logic, if you wont help me, dont reply it /end

If someone could give sugestions, i would be thankfull.

[Fou-Lu]

As stated, it is your data, and you can interpret it however you want. Personally, I would not call it Administrator as that would be at minimum char(13) or 8 *13 = 104 bytes. This is much more expensive than 4bytes required by an int, and if you are talking about usergroups, you can probably get away with a tinyint which is a single byte (giving you up to 256 possible values, or 255 excluding the 0). So if you were to do that, it would be 1/104'th the size for that record (depending of course on the property type and value, I'm just comparing it to the string "Administrator").

Instead, use the numerical value provided and join it to another table which has the text to display. Unless you need to store that data for whatever historical reasons, than you are much better off using the numerical value and joining in the data you need than to store the textual data it represents.