How can I add data to a DB? PHP MySQL

Question

I seem to not be inserting data into fields properly. The fields and tables all exists and I'm positive that I'm connecting to the database correctly. The fields all remain empty :(

  $query = ("INSERT INTO 'users' (phone) VALUES ('$phone') WHERE username='$userid'");
  mysql_query($query);

if that is the exact query you are sending try to replace the single quotes around the table name with a ` like so: `users` — BigFatBaby
– BigFatBaby, Commented May 30, 2011 at 15:26

user453441 · Accepted Answer · 2011-05-30 15:26:30Z

4

INSERT doesn't have a WHERE in it's syntax:

http://dev.mysql.com/doc/refman/5.5/en/insert.html

answered May 30, 2011 at 15:26

user453441

1,1562 gold badges14 silver badges26 bronze badges

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

Comments

arthur86 · Accepted Answer · 2011-05-30 15:29:05Z

3

You should use update query :

  $query="UPDATE users
    SET phone='$phone'
    WHERE username='$userid'";

answered May 30, 2011 at 15:29

arthur86

5311 gold badge3 silver badges20 bronze badges

1 Comment

Paul Sasik Over a year ago

+1 It definitely looks like the OP is mistaking an INSERT for an UPDATE.

Haru · Accepted Answer · 2011-05-30 15:27:48Z

0

You should be using update....

mysql_select_db("my_db", $con);

mysql_query("UPDATE Persons SET Age = '36'
WHERE FirstName = 'Peter' AND LastName = 'Griffin'");

mysql_close($con);

answered May 30, 2011 at 15:27

Haru

1,3812 gold badges15 silver badges41 bronze badges

Collectives™ on Stack Overflow

How can I add data to a DB? PHP MySQL

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related