using INSERT into construct to add data into a table

[pattie]

I hava been trying to add data into a table using INSERT into unsuccessfully.Doing it manually works,and all other constructs works like SELECT,UPDATE.So what might be a cause.


My syntax

$query= INSERT into table Product("prod_name","prod_ID","description")
VALUES('sony','s12','Mega pixels');


P'se help me coz it is ril disturbing me.....

[mwasif]

Do not use quotes around column names. The correct syntax is

[PHP]$query= "INSERT into table Product(prod_name,prod_ID,description)
VALUES('sony','s12','Mega pixels')";[/PHP]

[kovik]

Yeah, it's always a goo idea to practice your SQL either on a database or (if you must) in phpMyAdmin.