// User Form With Drop Down Box
Please Enter The User's ID You'd Like To Change
User
User Rank
 
// Function changeUserRank() function changeUserRank() { if(!is_numeric($_POST['form_id'])) return 2; if(!is_numeric($_POST['form_rank'])) return 2; if(empty($_POST['form_id'])) echo "Form Field 'USER' Not Entered.
Click Here to try again."; if(empty($_POST['form_rank'])) echo "Form Field 'RANK' Not Entered.
Click Here to try again."; $idE = $_POST['form_id']; $id = htmlentities($idE, ENT_QUOTES); $rankE = $_POST['form_rank']; $rank = htmlentities($rankE, ENT_QUOTES); $query = "UPDATE `users` SET `rank`='$rank' WHERE `id`='$id'"; $sql = mysql_query($query); if(mysql_affected_rows()==0) return 0; else return 1; } // Handler for changeUserRank() function if(isset($_POST['changeUserRank'])) { $ret = changeUserRank(); if($ret==0) echo "Unable To Update User ID"; elseif($ret==1) echo "User ID Updated!."; elseif($ret==2) echo "Non-Numeric ID Entered!.
Click Here to try again."; } else { // Display above form