'.$row["username"].': '.$row["score"].'

'; } exit(); } if(isset($_GET['new_score'])){ $new_score = $_GET['new_score']; $username = "[USER_NAME]"; $scores = []; while($row = mysqli_fetch_assoc($result)){ array_push($scores, $row['score']); } if($new_score > $scores[0]){ $sql = "UPDATE `snake` SET `username` = '$username', `score` = '$new_score' WHERE rank=1"; mysqli_query($conn, $sql); echo 'Congratulations RANK_1 exceeded :)'; exit(); }else if($new_score > $scores[1]){ $sql = "UPDATE `snake` SET `username` = '$username', `score` = '$new_score' WHERE rank=2"; mysqli_query($conn, $sql); echo 'Congratulations RANK_2 exceeded :)'; exit(); }else if($new_score > $scores[2]){ $sql = "UPDATE `snake` SET `username` = '$username', `score` = '$new_score' WHERE rank=3"; mysqli_query($conn, $sql); echo 'Congratulations RANK_3 exceeded :)'; exit(); }else if($new_score > $scores[3]){ $sql = "UPDATE `snake` SET `username` = '$username', `score` = '$new_score' WHERE rank=4"; mysqli_query($conn, $sql); echo 'Congratulations RANK_4 exceeded :)'; exit(); }else if($new_score > $scores[4]){ $sql = "UPDATE `snake` SET `username` = '$username', `score` = '$new_score' WHERE rank=5"; mysqli_query($conn, $sql); echo 'Congratulations RANK_5 exceeded :)'; exit(); }else{ echo 'Try again to hit a new record :)'; exit(); } } ?>