Problem with sql insert command

[NotOnUrNelly]

Hi All

Could anyone help me with the following line of sql code

$sql_text = "insert into tblPeaksBagged values ('',$SummitNo,1,'$POST[Sum_Bag_Date]','$POST[Sum_Bag_Accomp]','$POST[Sum_Bag_Weather]','$POST[Sum_Bag_Comments]')";

I am having problems somewhere around the area of the variable $SummitNo

and the following 1

If I put them into inverted comma's

$sql_text = "insert into tblPeaksBagged values ('','$SummitNo','1','$POST[Sum_Bag_Date]','$POST[Sum_Bag_Accomp]','$POST[Sum_Bag_Weather]','$POST[Sum_Bag_Comments]')";

everything except $SummitNo is entered into the database

if I leave the inverted commas

as shown at first

the $summitNo variable is entered into the db and so is the 1, but nothing else.

I am sure it is just a problem with my syntax, hope someone can help.

Thanks
Jamie

[NotOnUrNelly]

Hi,

Can anyone help me with the above code, I have been trying all weekend and still cant manage it

Thanks Again

[liudaheng]

why you got "," before $SummitNO?,
or if you want SummitNO as primary key in database , set it as INT, and auto_increment, and not need to INSERT this value as well. then it will increase one by one.