Jiraiya Posted January 26, 2009 Share Posted January 26, 2009 I was wondering if i would be able to expand on this code i made so that it does the same thing but for different set numbers kinda like this if kills >50 & <100 set rank x if rank = x echo cannot rank up if kills >100 & < 150 set rank x if rank = x echo... if kills > 150 & < 200 set rank x if rank = x but with it being all in one script, and how would i do this this my current code shown below. $sql = mysql_query("SELECT * FROM table WHERE username = '$username'"); $row = mysql_fetch_array($sql); if($row['kills'] >= 25){ mysql_query("UPDATE `table` SET `variable` = 'new rank' WHERE username = '$username'") or die(mysql_error()); echo '<center>You have ranked up. '.$username.'</center>'; }else{ echo '<center>Your not good enough to rank up yet!</center>'; } Quote Link to comment https://forums.phpfreaks.com/topic/142472-solved-i-need-some-help/ Share on other sites More sharing options...
RichardRotterdam Posted January 26, 2009 Share Posted January 26, 2009 use elseif $sql = mysql_query("SELECT * FROM table WHERE username = '$username'"); $row = mysql_fetch_array($sql); if($row['kills'] == 0){ echo '<center>Your not good enough to rank up yet!</center>'; }elseif($row['kills'] >= 25){ mysql_query("UPDATE `table` SET `variable` = 'new rank' WHERE username = '$username'") or die(mysql_error()); echo '<center>You have ranked up. '.$username.'</center>'; }elseif(){ //ETC } Quote Link to comment https://forums.phpfreaks.com/topic/142472-solved-i-need-some-help/#findComment-746494 Share on other sites More sharing options...
Jiraiya Posted January 26, 2009 Author Share Posted January 26, 2009 the "kills" variable is never reset to 0 it keeps increasing Quote Link to comment https://forums.phpfreaks.com/topic/142472-solved-i-need-some-help/#findComment-746515 Share on other sites More sharing options...
RichardRotterdam Posted January 27, 2009 Share Posted January 27, 2009 if its never 0 then you could do if($row['kills'] <25 ){ } instead of ==0 Quote Link to comment https://forums.phpfreaks.com/topic/142472-solved-i-need-some-help/#findComment-747361 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.