Why can't I Update mysql table?

Question

My sql table is not updating. I have looked through tons of documentation and I do not see why it is not working.

if (!empty($_POST['services'])){
    $username = mysql_real_escape_string($_POST['username']);
    $service = mysql_real_escape_string($_POST['services']);
    $registerquery = mysql_query("UPDATE users SET service = '".$service."' WHERE Username = '".username."'");
}

Answer 1

My error was that I wrote this: $registerquery = mysql_query("UPDATE users SET service = '".$service."' WHERE Username = '".username."'"); and I was missing the $ and an s in services. To correct this: $registerquery = mysql_query("UPDATE users SET services = '".$service."' WHERE Username = '".$username."'"); Thank you all for your help. I submitted another answer last night saying I found the error.

Answer 2

Please update your code to use PDO. Inserting into the database could be much easier and safer using prepared statements.

For example:

<?php
    $stmt = $db->prepare("UPDATE `users` SET `services`=:service WHERE `username`=:username");
    $stmt->execute(array(':username' => $username, ':service' => $service));
?>

Here's a good resource when learning the basics of PDO. http://wiki.hashphp.org/PDO_Tutorial_for_MySQL_Developers

Have a good one! - Scott

Answer 3

I have tried to close this twice. All I had to do was add a "s" at the end of "service" in the update command. I overlooked the fact it did not match the requested field in the table.

Answer 4

Please replace like this and execute.

 $registerquery = mysql_query("UPDATE users SET service = '".$service."' WHERE Username = '".$username."'");