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>'; } 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 } 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 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 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
Archived
This topic is now archived and is closed to further replies.