<?php session_start(); include_once('../../../db/saucerer.php'); if(isset($_GET['url'])){ $id = $_GET['id']; $gender = $_GET['gender']; $sql = "UPDATE listings SET gender = '$gender' WHERE id = '$id'"; //use for MySQLi OOP if($conn->query($sql)){ $_SESSION['success'] = 'Gender assigned as '.$gender.' successfully'; } else{ $_SESSION['error'] = 'Something went wrong while assigning the gender!'; } } header('location: ../../'); ?>