Mysql Update Query PHP Not working

Question

i need your help.. i having a problem with mysql, when i run UPDATE query, the data wont updated..

here's the structure..

id_demand   | nama_item | hargajual | hargabeli | barcode   | part_number   | nosc  | stat_gudang   | stat_po   | stat_gudang2  | request   | terima    | id_po | id_pr | id_npb    | id_ttb    | tanggal_request   | tanggal_terima    | final_stat    | tipe

and here's the query...

$sqlx = "UPDATE item_demand SET stat_gudang = '1' AND id_pr = '$id_PR' WHERE id_npb = '2'";        
mysql_query($sqlx) or die(mysql_error());

I dont know why is my query doesnt work, can anybody help me?

The above query will throw an error message. Please always quote the error message as well — Pekka
– Pekka, Commented Jul 30, 2012 at 7:46

Pierre Arlaud · Accepted Answer · 2012-07-30 07:44:56Z

2

I'm assuming you didn't get any errors ? It probably means your where condition isn't verified then.

EDIT: I just saw your syntax was wrong. Your SET clauses must be separated by commas and not "AND". Thus : SET stat_gudang = '1', id_pr = '$id_PR'

answered Jul 30, 2012 at 7:44

Pierre Arlaud

4,1523 gold badges31 silver badges45 bronze badges

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

Comments

Undermine2k · Accepted Answer · 2012-07-30 07:47:48Z

0

Make sure you are including data for the primary key and all foreign key constraints in your update.

answered Jul 30, 2012 at 7:47

Undermine2k

1,4914 gold badges28 silver badges53 bronze badges

Comments

Abid Hussain · Accepted Answer · 2012-07-30 08:22:48Z

0

you have used AND Bitween two field

stat_gudang = '1' AND id_pr = '$id_PR'

Change code

stat_gudang = '1', id_pr = '$id_PR'

$sqlx = "UPDATE item_demand SET stat_gudang = '1', id_pr = '$id_PR' WHERE id_npb = '2'";        
mysql_query($sqlx) or die(mysql_error());

answered Jul 30, 2012 at 8:22

Abid Hussain

7,7694 gold badges38 silver badges57 bronze badges

Collectives™ on Stack Overflow

Mysql Update Query PHP Not working

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related