mysql insert PHP statement keeps throwing error

Question

Does anybody know why the following PHP code keeps throwing errors: I have been unable to log any proper error other than the if statement $result not going through and giving me the Echo 'Error' statement. Is there something wrong with my insertion?

    $new_tbl_name = 'Password_Reset';

   $sql = "INSERT INTO $new_tbl_name (Email, Key) VALUES ('$email','$resetHash')";

   $result = mysql_query($sql);


    if ($result) {
    }
    else {
       echo 'Error';
     }

Echo mysql_error() to get more specific information.

scottlimmer
– scottlimmer

2012-10-07 01:24:08 +00:00
Commented Oct 7, 2012 at 1:24 — scottlimmer
– scottlimmer, Commented Oct 7, 2012 at 1:24

Marc B · Accepted Answer · 2012-10-07 01:25:29Z

3

key is a reserved word, you'll have to escape it:

INSERT INTO $new_tbl_name (Email, `Key`) VALUES
                                  ^   ^

As a general suggestion, simply saying "error" is utterly useless for debugging purposes. Have mysql TELL you what's wrong:

if (!$result) {
   die(mysql_error());
}

so you have a clue as to what's wrong, instead of just poking around in the dark.

answered Oct 7, 2012 at 1:25

Marc B

362k44 gold badges433 silver badges508 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Apollo Over a year ago

wow. Unbelievable. Thank you for saving me from breaking some

Barmar Over a year ago

The error message probably wouldn't have helped in this case anyway. MySQL's syntax errors tend to be very generic. All it probably would say is that the error is at the word Key, but it won't tell you WHY it's wrong.

Collectives™ on Stack Overflow

mysql insert PHP statement keeps throwing error

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related