[RESOLVED] Using the SET command

[dcjones]

Hi all.

I need to change the data in 2 feilds with my data table. I am able to change the first one but not the second one.

I have 2 feilds: "processed" datatype INT and "batch_id" datatype DATE,

If I use

$updateSQL = sprintf("UPDATE payments SET processed='1' where processed = '0'");

This works fine, but when I introduce a second feild it fails.

$updateSQL = sprintf("UPDATE payments SET processed='1' where processed = '0', batch_id = '('DATE: Auto NOW()', NOW())'");

Can anyone see where I am going wrong.

[NogDog]

The WHERE clause must come after the SET clause, not in the middle of it.

[dcjones]

Hi NogDog

Many thanks for your reply.

I have adjusted the query to:

$updateSQL = sprintf("UPDATE amember_baggagepayments SET processed='1', batch_id ='NOW()' where processed = '0' AND batch_id='0000-00-00'");

This partly works, the part that does not is the "batch_id". The data that gets written to this feilds is "0000-00-00" and not todays date. Is there anything you can see that would cause this.

Many thanks again.

[NogDog]

Remove the quotes from around NOW() -- it's a SQL function, not a string literal. 🙂

[dcjones]

Hi NogDog,

Many thanks, And Marked Resolved