updater straight to 1 but make mistakes all the time

[szen]

hey this is how I'm going with building a system as possible to get an email that you have signed up to. then I had build up so that when you click on the link that you get the email so it must be seen if it has rank 0 or 1 and if it is rank 1 then it should just say well, you have approved your account. and if it is 0 then the only updater it to rank 1 so it will be possible.\[code\]<?php include ("include/database/db.php"); if($stmt = $mysqli->prepare("SELECT `code` FROM `brugere` WHERE `code` = ?")) { $stmt->bind_param('i', $g_code); $g_code = $_GET["code"]; $stmt->execute(); $stmt->store_result(); $stmt->bind_result($code); $stmt->fetch(); $count_res = $stmt->num_rows; $stmt->close(); if($count_res > 0) { if($code == 0) { if($stmt = $mysqli->prepare("UPDATE brugere SET `code`=1 WHERE `code`=?")) { $stmt->bind_param('i', $g_code); $g_code = $_GET["code"]; $stmt->execute(); $stmt->close(); } echo 'Din bruger er blevet godkendt'; } if($code == 1) { echo 'Din bruger er allerede godkendt'; } } else { /* Der er opst?