PHP PDO - MySQL INSERT with WHERE

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

Check [this](http://stackoverflow.com/questions/485039/mysql-insert-where-query) out — BlitZ, May 07 '13 at 07:16
:) I just read what you said.... I need UPDATE... so sorry... — Adam, May 07 '13 at 07:17
thankyou guys... I'll be smarter in the future... appologies... — Adam, May 07 '13 at 07:17

score 3 · Accepted Answer · edited May 07 '13 at 07:38

3

maybe you mean UPDATE

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

edited May 07 '13 at 07:38

Yogesh Suthar

30,424
18
72
100

answered May 07 '13 at 07:18

John Woo

258,903
69
498
492

:) cheers... appreciated... – Adam May 07 '13 at 07:18

PHP PDO - MySQL INSERT with WHERE

1 Answers1