SQL INSERT with no errors

Question

I have a problem where I get no errors nothing it all goes though as if nothing was wrong! I had all this working then all of a sudden it just stopped working. All my other SQL stuff works on my script apart from this:

// Submit the form and enter the details into the database
    $result = $dbc->prepare('INSERT INTO users (user_name, pwd, date, user_level) values(?,?,?,?)');
    $result->bind_param('sssi', $username, $hash, $now, $userlevel);
    printf("Errormessage: %s\n", $result->error);
    $result->execute();
    $result->close();

It returns no errors nothing. Its very strange. Nothing is inserted into the DB.

Try outputting the error after execute as well. One thing that stands out is that date is a reserved word — Pekka
– Pekka, Commented Jun 17, 2012 at 15:25

cypher · Accepted Answer · 2012-06-17 15:25:26Z

1

Maybe first execute, then check the error message?

    $result = $dbc->prepare('INSERT INTO users (user_name, pwd, date, user_level) values(?,?,?,?)');
    $result->bind_param('sssi', $username, $hash, $now, $userlevel);
    $result->execute();
    printf("Errormessage: %s\n", $result->error);
    $result->close();

answered Jun 17, 2012 at 15:25

cypher

7,0024 gold badges34 silver badges48 bronze badges

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

1 Comment

CallumBee Over a year ago

That got it! was due to me forgetting to remove a unused column in the DB. It threw the error (After putting the error script in the right place!) thanks :)

Collectives™ on Stack Overflow

SQL INSERT with no errors

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related