Jump to content


This topic is now archived and is closed to further replies.


MySQL set datatype

Recommended Posts


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]


Share this post

Link to post
Share on other sites
I guess, i'll change the ranks to number, and make an array with the rank names in. Then link the two.

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.