INSERT query WHERE condition?

Question

My code is

$queryinsert = mysql_query("
        INSERT INTO studentdata (offsiteleft)
        VALUES ($m_offsiteleft)
        WHERE studentid = '$name'
        ") 
    or die("Error querying database (Offsite minutes INSERT query) ".mysql_error());

Giving me this error

Error querying database (Offsite minutes INSERT query) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE studentid = '31'' at line 3

Do you want to update an existing query? Then use `update`, not `insert`. `insert` does not have a `where` clause. — juergen d, Apr 18 '14 at 21:45
possible duplicate of http://stackoverflow.com/questions/485039/mysql-insert-where-query — Sanketh, Apr 18 '14 at 21:46
`UPDATE studentdata SET offsiteleft ='$m_offsiteleft' WHERE studentid = '$name'` — M Khalid Junaid, Apr 18 '14 at 21:47

score 0 · Answer 1 · answered Apr 18 '14 at 21:48

0

UPDATE studentdata
SET offsiteleft = $m_offsiteleft
WHERE studentid = '$name'

answered Apr 18 '14 at 21:48

Thanks, I didnt know about UPDATE – user3429811 Apr 18 '14 at 21:49

INSERT query WHERE condition?

1 Answers1