php query row update

Question

i wanna update one row:

do_mysql_query("UPDATE helpcenter SET solved=$solved WHERE id=$id");

and my second update:

do_mysql_query("UPDATE helpcenter SET check=1 WHERE id=$id");

$id in these two are same. How join them together, so only one sql would be ?

Hopefully you're sanitizing $id properly, so little Bobby Tables won't be able to play with your database. — Marc B
– Marc B, Commented Apr 13, 2011 at 17:56

Chandu · Accepted Answer · 2011-04-13 17:44:18Z

2

You need to seperate the fields being updated with , (comma)
Try this:

do_mysql_query("UPDATE helpcenter SET solved=$solved, check=1 WHERE id=$id");

answered Apr 13, 2011 at 17:44

Chandu

83.2k19 gold badges136 silver badges136 bronze badges

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

2 Comments

Chandu Over a year ago

@Neal: yes, but I think you were faster than me by 13 seconds :)

Naftali Over a year ago

hehe to the victor goes the spoils ^_^

Naftali · Accepted Answer · 2011-04-13 17:43:59Z

2

commas.

do_mysql_query("UPDATE helpcenter SET solved=$solved, check=1 WHERE id=$id");

answered Apr 13, 2011 at 17:43

Naftali

147k41 gold badges247 silver badges304 bronze badges

Comments

Dennis Lauritzen · Accepted Answer · 2011-04-13 17:44:33Z

0

do_mysql_query("UPDATE helpcenter SET check = 1, solved = '".$solved."' WHERE id = ".$id.");

This should do the work.

answered Apr 13, 2011 at 17:44

Dennis Lauritzen

4043 gold badges8 silver badges21 bronze badges

1 Comment

Naftali Over a year ago

why are you changing the sql statement with '".? there is no need for that

SPoage · Accepted Answer · 2011-04-13 17:58:45Z

0

Like the others above, this should work:

do_mysql_query("UPDATE helpcenter SET solved='$solved', check=1 WHERE id='$id'");

However, be sure to sanitize $id and $solved properly using mysql_real_escape_string() or something equivalent.

answered Apr 13, 2011 at 17:58

SPoage

1,0971 gold badge7 silver badges12 bronze badges

Comments

Sean · Accepted Answer · 2012-08-12 05:27:38Z

0

do_mysql_query("UPDATE helpcenter SET solved=$solved, check=1 WHERE id=$id");

edited Aug 12, 2012 at 5:27

user212218

answered Apr 13, 2011 at 17:44

Sean

6815 silver badges11 bronze badges

Collectives™ on Stack Overflow

php query row update

5 Answers 5

2 Comments

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related