PHP MYSQL Update multiple fields including DATETIME field

Question

I can update the field 'delivered' from 0 to 1 no problem but when I try to update 'delivered_time' nothing happens in the database. This may be to do with the way I am writing the code but If anybody could help I would really appreciate it, thanks!

if (isset($_POST['delivered']) === false) {
                mysql_query("UPDATE `listings` SET `delivered_time` = '{$date->format('Y-m-d H:i:s')}' AND `delivered` = 1 WHERE `order_id` = $order_id");
}

I have also tried this but this did not work either

if (isset($_POST['delivered']) === false) {
                    mysql_query("UPDATE `listings` SET `delivered_time` = NOW() AND `delivered` = 1 WHERE `order_id` = $order_id");
}

My MYSQL database is set to have 'delivered' defined to 0 and is stored as an INT value. The 'delivered_time' field is stored as a DATETIME value in the database.

You can't use ANDwhen using SET, you have to use comas.

Matteo
– Matteo

2014-01-01 12:41:23 +00:00
Commented Jan 1, 2014 at 12:41 — Matteo
– Matteo, Commented Jan 1, 2014 at 12:41

Mark Baker · Accepted Answer · 2014-01-01 12:38:54Z

3

, not AND as the field separator; AND is used in WHERE clauses

UPDATE `listings` 
   SET `delivered_time` = '{$date->format('Y-m-d H:i:s')}',
       `delivered` = 1 
 WHERE `order_id` = $order_id

answered Jan 1, 2014 at 12:38

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

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

Comments

Rizwan Sultan · Accepted Answer · 2014-01-01 12:41:14Z

2

Try this code

<?php

if (isset($_POST['delivered']) === false) {
    mysql_query("UPDATE `listings` SET `delivered_time` = NOW(),`delivered` = 1 WHERE `order_id` = ".$order_id);
}
?>

answered Jan 1, 2014 at 12:41

Rizwan Sultan

18710 bronze badges

Collectives™ on Stack Overflow

PHP MYSQL Update multiple fields including DATETIME field

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related