How to update two fields in mysql using php via a input form

Question

I believe I have a issue with in mysql query. Please take a look at the code and let me know if there is something wrong in this statement.

$sql = "UPDATE `Blog` SET `Employee_Name` = '$emp_name', 'Employee_Email' = '$emp_email'      WHERE `Blog`.`Id` = '$emp_id'";

yes,you are using quotes for column names ,use back ticks.You started fine,than went back to quotes. — Mihai
– Mihai, Commented Apr 10, 2014 at 17:15

Marc B · Accepted Answer · 2014-04-10 17:15:34Z

1

Bad quoting:

$sql = "UPDATE `Blog` SET `Employee_Name` = '$emp_name', 'Employee_Email' = '$emp_email'      
                                                         ^--------------^---

The indicated quotes should be backticks (`), not single quotes (').

And if you had proper (or any at all) proper error handling on your query calls, you'd have been told about the syntax error.

answered Apr 10, 2014 at 17:15

Marc B

362k44 gold badges433 silver badges508 bronze badges

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

3 Comments

Adema_It_Man Over a year ago

It worked. Im a newbie so thanks for even taking the time. Such a simple mistake.

Marc B Over a year ago

No worries. But do add error handling. e.g. $result = mysql_query($sql) or die(mysql_error()). Never assume a query succeeded. Always assume failure, and treat success as a pleasant surprise. Even this basic type of "bail out on failure" will help while developing and tell you exactly what went wrong.

Mohammed Joraid Over a year ago

If the answers works for you, then mark it as a correct answer so others can benefit from it as well. Aside note, try to write your query in a query editor first (such as SQLYOG) to check it's correctness since the sql tool will format and color highlight your query which will make it easier to detect errors.

Collectives™ on Stack Overflow

How to update two fields in mysql using php via a input form

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related