PHP PDO - MySQL INSERT with WHERE [duplicate]

Question

Can someone give me a kick in the right direction with this:

    $sql='INSERT INTO table (name,data,other,datetime) VALUES (?,?,?,NOW()) WHERE id=?;';
    $pds=$database->pdo->prepare($sql);
    $pds->execute(array($a,$b,$c,$id));

what are I doing wrong here?

Note: I've INSERTED before successfully using PDO. The only difference is the WHERE id=?...

thankyou

:) I just read what you said.... I need UPDATE... so sorry... — Adam
– Adam, Commented May 7, 2013 at 7:17
thankyou guys... I'll be smarter in the future... appologies... — Adam
– Adam, Commented May 7, 2013 at 7:17

Yogesh Suthar · Accepted Answer · 2013-05-07 07:38:46Z

3

maybe you mean UPDATE

UPDATE `table` 
SET    `name` = ?,
       `data` = ?,
       `other` = ?,
       `datetime` = ?
WHERE  `id` = ?

edited May 7, 2013 at 7:38

Yogesh Suthar

30.5k18 gold badges75 silver badges100 bronze badges

answered May 7, 2013 at 7:18

John Woo

265k70 gold badges509 silver badges500 bronze badges

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

1 Comment

Adam Over a year ago

:) cheers... appreciated...

Collectives™ on Stack Overflow

PHP PDO - MySQL INSERT with WHERE [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related