Jump to content

Archived

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

Cruisecar

MySQL set datatype

Recommended Posts

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

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.