INSERT INTO error

[Rayn]

query:

$DB_site->query("INSERT INTO reviewsections SET title='".addslashes($title)."',sectiondesc='".addslashes($sectiondesc)."',active='$active' WHERE reviewsectionsid='$rsid'");

error:

Invalid SQL: INSERT INTO reviewsections SET title='Test',sectiondesc='asfd',active='1' WHERE reviewsectionsid='1'
mysql error: 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 reviewsectionsid='1'' at line 1

mysql error number: 1064

I cant see any errors..can someone spot me on this?

Thanks
- Rayn

[barand]

Can you have a where clause in an insert statement?

[Doug_G]

I don't think you can use a WHERE clause with INSERT INTO

[kevinsequeira]

u need to use UPDATE

$DB_site->query("UPDATE reviewsections SET title='".addslashes($title)."',sectiondesc='".addslashes($sectiondesc)."',active='$active' WHERE reviewsectionsid='$rsid'");

reg
kevin

[Rayn]

hahah yes I do.. I cant believe I missed that.

Thanks

[tdevlin]

Please mark this as resolved..

Thank you!!
Tony Devlin