Using variables in MySQL UPDATE (PHP/MySQL)

Question

I am using this code so I can update a record in database:

$query = mysql_query("UPDATE article 
                         SET com_count = ". $comments_count 
                       WHERE article_id = .$art_id ");

My question is: How can I use variables in a MySQL UPDATE statement.

morgar · Accepted Answer · 2011-04-30 00:55:20Z

13

$query = mysql_query("UPDATE article set com_count = $comments_count WHERE article_id = $art_id");

You was messing up the quotes and concats.

You can use inline vars like the previous example or concat them like:

$query = mysql_query("UPDATE article set com_count = " . $comments_count . " WHERE article_id = " . $art_id);

answered Apr 30, 2011 at 0:55

morgar

2,41718 silver badges17 bronze badges

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

2 Comments

MU_FAM Over a year ago

believe me i would but ..it's said my reputation should be more than 15 ..and it doesn't ..sorry man

Hnatt Over a year ago

Here you go, now you have 16. Don't thank me, just accept the answer so the question could be marked as solved.

dee-see · Accepted Answer · 2011-04-30 00:55:24Z

4

You messed up on your " . pattern.

$query = mysql_query("UPDATE article set com_count = ". $comments_count . " WHERE article_id = " . $art_id . ");

answered Apr 30, 2011 at 0:55

dee-see

24.1k6 gold badges63 silver badges92 bronze badges

Comments

fredtantini · Accepted Answer · 2014-10-27 13:05:42Z

2

Use apostrophes when using variables in a MySQL UPDATE statement:

$query = mysql_query("UPDATE article 
                      SET com_count =  '$comments_count'
                      WHERE article_id = '$art_id'");

Be careful about space and apostrophes.

edited Oct 27, 2014 at 13:05

fredtantini

16.6k8 gold badges51 silver badges58 bronze badges

answered Oct 27, 2014 at 12:21

Fahim Faysal

4694 silver badges6 bronze badges

Collectives™ on Stack Overflow

Using variables in MySQL UPDATE (PHP/MySQL)

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related