mysql_query UPDATE not updating

[Foser]

if (isset($_POST['submit'])) {

if (isset($_POST['username_check'])){
mysql_query("UPDATE user_info SET username = {$_POST[username]} WHERE username = {$username}");
}}

 

for some reason it does not update. the statement gets passed but it never updates. I have put in an echo in each if statement to test if they get passed and they do. they just dont update.

[Harley1979]

Try:

 

if (isset($_POST['submit'])) {

if (isset($_POST['username_check'])){
mysql_query("UPDATE user_info SET username = '$_POST[username]' WHERE username = '$username'");
}}

[MemphiS]

if (isset($_POST['submit'])) {

  if (isset($_POST['username_check'])){
  mysql_query("UPDATE user_info SET username = '".$_POST['username']."' WHERE username = '$username'");
  }
}

 

Should work..