MySQL set datatype

[Cruisecar]

Hey,

I have a mysql set datatype, with many different possible values. I need to fetch the current value from the database, and move up to the next value on the set datatype. I read you could do this with numbers some how (eg adding 1)? In the database the set values are basicly a rank system using words.

[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]
$query = "select * from users where username='$username'";
$result = mysql_query($query, $con);
$stats = mysql_fetch_array($result);
if($stats['next_lvl'] >= "100")
{
//Rank up to next level script goes here,
} [/quote]

Thankyou

[Cruisecar]

Anyone :( ?

[Cruisecar]

I guess, i'll change the ranks to number, and make an array with the rank names in. Then link the two.