Hi, i have an update query for admin users who update users information, except the code doesnt seem to be changing any details in the mysql database, any help would be great thanks.
<?php
ini_set( 'display_errors', '1' );
error_reporting ( 2047 );
$host="localhost"; // Host name
$username="root"; // Mysql username
$password="root"; // Mysql password
$db_name="test"; // Database name
$tbl_name="members"; // Table name
// Connect to server and select databse.
mysql_connect("$host", "root", "root")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$row = $_SESSION['members'][0];
$myid=$_POST['myid'];
$myfirstname=$_POST['myfirstname'];
$mysurname=$_POST['mysurname'];
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];
$myemail=$_POST['myemail'];
$mybrowser=$_POST['mybrowser'];
mysql_select_db("test");
mysql_query("UPDATE members SET(Firstname, Surname, username, password, email, level)
VALUES ('$_POST[myfirstname]', '$_POST[mysurname]', '$_POST[myusername]', '$_POST[mypassword]', '$_POST[myemail]', '$_POST[mybrowser]')");
echo "Updated";
?>
