cannot update mysql table with php

Question

Cannot update my table with the follow code...have been trying for hours... tagboard is the table name, mytag1 is what I want to update with reference to emailadd.

$myemail = mysql_real_escape_string( $_POST["myemail"] );
$mytag1 = mysql_real_escape_string( $_POST["mytag1"] );
echo $mytag1;
$query = "UPDATE tagboard SET mytag1='{$mytag1}' WHERE emailadd = {$myemail}";
$result=mysql_query($query);

OR

$sql="UPDATE tagboard SET mytag1 ='".$_POST['mytag1']."' WHERE  myemail='".$_POST['myemail']."'";
$result=mysql_query($sql);

Appreciate your help!

@mikeB thanks! --- This is my error: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@gmail.com' at line 1" What am I suppose to do?? I will google it but if you already know..... — minjiera
– minjiera, Commented Oct 10, 2013 at 19:28
And I caught a few more errors... I called the column tag1 not mytag1 in the table, but I am sending mytag1....Just started learning php recently. Sorry for being stupid. And many thanks! — minjiera
– minjiera, Commented Oct 10, 2013 at 19:36

Crackertastic · Accepted Answer · 2013-10-10 19:32:33Z

1

Add quotes around your email address field in the query:

$query = "UPDATE tagboard SET mytag1='{$mytag1}' WHERE emailadd = '{$myemail}'";

answered Oct 10, 2013 at 19:32

Crackertastic

4,9232 gold badges33 silver badges40 bronze badges

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

1 Comment

Tran Anh Minh Over a year ago

Thank you very much :)) It works for me! Have been figuring this out for a while now

Touch · Accepted Answer · 2013-10-10 19:32:46Z

0

You have this line:

$query = "UPDATE tagboard SET mytag1='{$mytag1}' WHERE emailadd = {$myemail}";

Try putting single quotations around the email variable too

$query = "UPDATE tagboard SET mytag1='{$mytag1}' WHERE emailadd = '{$myemail}'";

answered Oct 10, 2013 at 19:32

Touch

1,50111 silver badges19 bronze badges

Collectives™ on Stack Overflow

cannot update mysql table with php

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related