Cruisecar Posted April 27, 2006 Share Posted April 27, 2006 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 Link to comment https://forums.phpfreaks.com/topic/8583-mysql-set-datatype/ Share on other sites More sharing options...
Cruisecar Posted April 29, 2006 Author Share Posted April 29, 2006 Anyone :( ? Link to comment https://forums.phpfreaks.com/topic/8583-mysql-set-datatype/#findComment-31914 Share on other sites More sharing options...
Cruisecar Posted April 29, 2006 Author Share Posted April 29, 2006 I guess, i'll change the ranks to number, and make an array with the rank names in. Then link the two. Link to comment https://forums.phpfreaks.com/topic/8583-mysql-set-datatype/#findComment-31930 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.