php - mysql update from html select option error -

php - mysql update from html select option error -

i have simple select alternative update users information, doesnt seem update in mysql.

have in code.

session_start(); $userid = $_get['id']; $userid = preg_replace("[^0-9]", "", $userid); $result = mysql_query("select first_name, last_name, active users userid='$userid' limit 1"); $row = mysql_fetch_assoc($result); if (isset($_post['submit'])) { $active = $_post["active"]; $sql= mysql_query("update users set active = '$active' userid='$userid' limit 1"); $succesmsg .= "<div class='alert alert-success alert-dismissable'> <i class='fa fa-ban'></i> <button type='button' class='close' data-dismiss='alert' aria-hidden='true'>x</button> business relationship gegevens gewijzigd </div>"; $_session['succes'] = $succesmsg; header("location: ".default_url_admin."/user/"); }

html

<form action="<?=$_server['php_self'];?>" method="post" enctype="multipart/form-data" name="active_user" class="standerdform"> <div class="box-body"> <div class="form-group"> <label>selecteer</label> <select class="form-control" id="active" name="active"> <option value="0" <?php if($row['active'] == 0) {echo 'selected';} ?>>deactiveren</option> <option value="1" <?php if($row['active'] == 1) {echo 'selected';} ?>>activeren</option> </select> </div> </div> <div class="box-footer"> <center> <a href="<?=default_url_admin?>/user/" class="btn btn-default marginright_20">annuleren</a> <input type="submit" name="submit" id="submit" class="btn btn-primary" value="opslaan"> </center> </div> </form>

i needed change

<?=$_server['php_self']

to

$_server['request_uri']

php mysql select option