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.S o what might be a cause.


My syntax

$query= INSERT into table Product("prod_n ame","prod_ID", "descriptio n")
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_na me,prod_ID,desc ription)
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.