MySQL update table row where column equals php variable

Question

I know that mysql_* is obsolete today, but I need to use it anyway at the moment. Could you please tell me how can I update a table where column equals php variable?

$qid = $_POST['idc'];
mysql_query("UPDATE `db`.`table` SET `status` = 'canceled' WHERE idc = $qid");

Thank you

what is this $qid = ['idc'];??

ɹɐqʞɐ zoɹǝɟ
– ɹɐqʞɐ zoɹǝɟ

2014-04-18 14:45:40 +00:00
Commented Apr 18, 2014 at 14:45 — ɹɐqʞɐ zoɹǝɟ
– ɹɐqʞɐ zoɹǝɟ, Commented Apr 18, 2014 at 14:45
just mistake, corrected

falcon
– falcon

2014-04-18 14:45:57 +00:00
Commented Apr 18, 2014 at 14:45 — falcon
– falcon, Commented Apr 18, 2014 at 14:45
what is your table name?

ɹɐqʞɐ zoɹǝɟ
– ɹɐqʞɐ zoɹǝɟ

2014-04-18 14:46:11 +00:00
Commented Apr 18, 2014 at 14:46 — ɹɐqʞɐ zoɹǝɟ
– ɹɐqʞɐ zoɹǝɟ, Commented Apr 18, 2014 at 14:46
So, MySQL is obsolete?

enapupe
– enapupe

2014-04-18 14:46:12 +00:00
Commented Apr 18, 2014 at 14:46 — enapupe
– enapupe, Commented Apr 18, 2014 at 14:46
he mean,mysql_* functions :)

ɹɐqʞɐ zoɹǝɟ
– ɹɐqʞɐ zoɹǝɟ

2014-04-18 14:46:37 +00:00
Commented Apr 18, 2014 at 14:46 — ɹɐqʞɐ zoɹǝɟ
– ɹɐqʞɐ zoɹǝɟ, Commented Apr 18, 2014 at 14:46

Pedro Lobito · Accepted Answer · 2014-04-18 14:46:32Z

1

 mysql_query("UPDATE `db`.`table` SET `status` = 'canceled' WHERE `idc` = '$qid'");

answered Apr 18, 2014 at 14:46

Pedro Lobito

99.8k36 gold badges274 silver badges278 bronze badges

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

3 Comments

Pedro Lobito Over a year ago

If it helped you, please consider accepting the answer, tks!

falcon Over a year ago

Yeah, i can do it in five minutes and i will, tnx

falcon Over a year ago

Sounds great, I like it

Collectives™ on Stack Overflow

MySQL update table row where column equals php variable

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