1064 - 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 ''1,1,'','',1,1,'',1,1,1,1,1,'',1,1,1,1,'','','','','','','','','','','','','',''' at line 1
<?php
include '../_includes/connection.php';
$foodtype=$_REQUEST['foodtype'];
$ffoodtype=$_REQUEST['ffoodtype'];
$water=$_REQUEST['water'];
$tea=$_REQUEST['tea'];
$ftea=$_REQUEST['ftea'];
$binge=$_REQUEST['binge'];
$junk=$_REQUEST['junk'];
$fruits=$_REQUEST['fruits'];
$ffruits=$_REQUEST['ffruits'];
$oil1=$_REQUEST['oil1'];
$oil2=$_REQUEST['oil2'];
$smoke=$_REQUEST['smoke'];
$fsmoke=$_REQUEST['fsmoke'];
$alcohol=$_REQUEST['alcohol'];
$falcohol=$_REQUEST['falcohol'];
$tobacco=$_REQUEST['tobacco'];
$ftobacco=$_REQUEST['ftobacco'];
$exercise=$_REQUEST['exercise'];
$fexercise=$_REQUEST['fexercise'];
$walking=$_REQUEST['walking'];
$healthdiscomforts=$_REQUEST['healthdiscomforts'];
$bp=$_REQUEST['bp'];
$readingbp=$_REQUEST['readingbp'];
$tabbp=$_REQUEST['tabbp'];
$heartproblem=$_REQUEST['heartproblem'];
$tmt=$_REQUEST['tmt'];
$angiogram=$_REQUEST['angiogram'];
$bypass=$_REQUEST['bypass'];
$diabetes1=$_REQUEST['diabetes1'];
$tdiabetes=$_REQUEST['tdiabetes'];
$fastdiabetes=$_REQUEST['fastdiabetes'];
$postdiabetes=$_REQUEST['postdiabetes'];
$tabdiabetes=$_REQUEST['tabdiabetes'];
$idiabetes=$_REQUEST['idiabetes'];
$mgdiabetes=$_REQUEST['mgdiabetes'];
$mencycle=$_REQUEST['mencycle'];
$sleep=$_REQUEST['sleep'];
$snore=$_REQUEST['snore'];
$stress=$_REQUEST['stress'];
$rstress=$_REQUEST['rstress'];
$ostress=$_REQUEST['ostress'];
$energy=$_REQUEST['energy'];
$bodycondition=$_REQUEST['bodycondition'];
$diabetes=$_REQUEST['diabetes'];
$status=$_REQUEST['status'];
$wweight=$_REQUEST['wweight'];
$mweight=$_REQUEST['mweight'];
$yweight=$_REQUEST['yweight'];
$tried=$_REQUEST['tried'];
$attempts=$_REQUEST['attempts'];
$lossweight=$_REQUEST['lossweight'];
$slossweight=$_REQUEST['slossweight'];
$name1=$_REQUEST['name1'];
$name2=$_REQUEST['name2'];
$name3=$_REQUEST['name3'];
$name4=$_REQUEST['name4'];
$name5=$_REQUEST['name5'];
$name6=$_REQUEST['name6'];
$name7=$_REQUEST['name7'];
$quantity1=$_REQUEST['quantity1'];
$quantity2=$_REQUEST['quantity2'];
$quantity3=$_REQUEST['quantity3'];
$quantity4=$_REQUEST['quantity4'];
$quantity5=$_REQUEST['quantity5'];
$quantity6=$_REQUEST['quantity6'];
$quantity7=$_REQUEST['quantity7'];
$days1=$_REQUEST['days1'];
$days2=$_REQUEST['days2'];
$days3=$_REQUEST['days3'];
$days4=$_REQUEST['days4'];
$days5=$_REQUEST['days5'];
$days6=$_REQUEST['days6'];
$days7=$_REQUEST['days7'];
$cost1=$_REQUEST['cost1'];
$cost2=$_REQUEST['cost2'];
$cost3=$_REQUEST['cost3'];
$cost4=$_REQUEST['cost4'];
$cost5=$_REQUEST['cost5'];
$cost6=$_REQUEST['cost6'];
$cost7=$_REQUEST['cost7'];
$waterrequired=$_REQUEST['waterrequired'];
$proteinrequired=$_REQUEST['proteinrequired'];
$oilused=$_REQUEST['oilused'];
$fruittake=$_REQUEST['fruittake'];
$nonveg=$_REQUEST['nonveg'];
$milkintake=$_REQUEST['milkintake'];
$coffee=$_REQUEST['coffee'];
$hungry=$_REQUEST['hungry'];
$gutaka=$_REQUEST['gutaka'];
$sweets=$_REQUEST['sweets'];
$destress=$_REQUEST['destress'];
$diabetics=$_REQUEST['diabetics'];
$medication=$_REQUEST['medication'];
$healing=$_REQUEST['healing'];
$program=$_REQUEST['program'];
$formula=$_REQUEST['formula'];
$payment=$_REQUEST['payment'];
$face=$_REQUEST['face'];
$chest=$_REQUEST['chest'];
$waist=$_REQUEST['waist'];
$hips=$_REQUEST['hips'];
$larms=$_REQUEST['larms'];
$rarms=$_REQUEST['rarms'];
$lthighs=$_REQUEST['lthighs'];
$rthighs=$_REQUEST['rthighs'];
$avail=$_REQUEST['avail'];
$rname1=$_REQUEST['rname1'];
$rname2=$_REQUEST['rname2'];
$rname3=$_REQUEST['rname3'];
$rname4=$_REQUEST['rname4'];
$rname5=$_REQUEST['rname5'];
$rname6=$_REQUEST['rname6'];
$rname7=$_REQUEST['rname7'];
$rname8=$_REQUEST['rname8'];
$rname9=$_REQUEST['rname9'];
$rname10=$_REQUEST['rname10'];
$rphone1=$_REQUEST['rphone1'];
$rphone2=$_REQUEST['rphone2'];
$rphone3=$_REQUEST['rphone3'];
$rphone4=$_REQUEST['rphone4'];
$rphone5=$_REQUEST['rphone5'];
$rphone6=$_REQUEST['rphone6'];
$rphone7=$_REQUEST['rphone7'];
$rphone8=$_REQUEST['rphone8'];
$rphone9=$_REQUEST['rphone9'];
$rphone10=$_REQUEST['rphone10'];
$rchallenge1=$_REQUEST['rchallenge1'];
$rchallenge2=$_REQUEST['rchallenge2'];
$rchallenge3=$_REQUEST['rchallenge3'];
$rchallenge4=$_REQUEST['rchallenge4'];
$rchallenge5=$_REQUEST['rchallenge5'];
$rchallenge6=$_REQUEST['rchallenge6'];
$rchallenge7=$_REQUEST['rchallenge7'];
$rchallenge8=$_REQUEST['rchallenge8'];
$rchallenge9=$_REQUEST['rchallenge9'];
$rchallenge10=$_REQUEST['rchallenge10'];
$rrelation1=$_REQUEST['rrelation1'];
$rrelation2=$_REQUEST['rrelation2'];
$rrelation3=$_REQUEST['rrelation3'];
$rrelation4=$_REQUEST['rrelation4'];
$rrelation5=$_REQUEST['rrelation5'];
$rrelation6=$_REQUEST['rrelation6'];
$rrelation7=$_REQUEST['rrelation7'];
$rrelation8=$_REQUEST['rrelation8'];
$rrelation9=$_REQUEST['rrelation9'];
$rrelation10=$_REQUEST['rrelation10'];
$str="insert into counsile (foodtype,ffoodtype,water,tea,ftea,binge,junk,fruits,ffruits,oil1,oil2,smoke,fsmoke,alcohol,falcohol,tobacco,ftobacco,exercise,fexercise,walking,healthdiscomforts,bp,readingbp,tabbp,heartproblem,tmt,angiogram,bypass,diabetes1,tdiabetes,fastdiabetes,postdiabetes,tabdiabetes,idiabetes,mgdiabetes,mencycle,sleep,snore,stress,rstress,ostress,energy,bodycondition,diabetes,status,wweight,mweight,yweight,tried,attempts,lossweight,slossweight,name1,name2,name3,name4,name5,name6,name7,quantity1,quantity2,quantity3,quantity4,quantity5,quantity6,quantity7,days1,days2,days3,days4,days5,days6,days7,cost1,cost2,cost3,cost4,cost5,cost6,cost7,waterrequired,proteinrequired,oilused,fruittake,nonveg,milkintake,coffee,hungry,gutaka,sweets,destress,diabetics,medication,healing,program,formula,payment,face,chest,waist,hips,larms,rarms,lthighs,rthighs,avail,rname1,rname2,rname3,rname4,rname5,rname6,rname7,rname8,rname9,rname10,rphone1,rphone2,rphone3,rphone4,rphone5,rphone6,rphone7,rphone8,rphone9,rphone10,rchallenge1,rchallenge2,rchallenge3,rchallenge4,rchallenge5,rchallenge6,rchallenge7,rchallenge8,rchallenge9,rchallenge10,rrelation1,rrelation2,rrelation3,rrelation4,rrelation5,rrelation6,rrelation7,rrelation8,rrelation9,rrelation10) values (";
$str=$str."
$foodtype,$ffoodtype,'$water',$tea,'$ftea',$binge,$junk,$fruits,$ffruits,'$oil1','$oil2',$smoke,'$fsmoke',$alcohol,$falcohol,$tobacco,'$ftobacco',$exercise,$fexercise,$walking,$healthdiscomforts,$bp,'$readingbp',$tabbp,'$heartproblem','$tmt','$angiogram','$bypass','$diabetes1,$tdiabetes,'$fastdiabetes','$postdiabetes',$tabdiabetes,$idiabetes,'$mgdiabetes',$mencycle,$sleep,$snore,$stress,$rstress,'$ostress',$energy,$bodycondition,$diabetes,$status,'$wweight','$mweight','$yweight','$tried','$attempts','$lossweight','$slossweight','$name1','$name2','$name3','$name4','$name5','$name6','$name7','$quantity1','$quantity2','$quantity3','$quantity4','$quantity5','$quantity6','$quantity7','$days1','$days2','$days3','$days4','$days5','$days6','$days7','$cost1','$cost2','$cost3','$cost4','$cost5','$cost6','$cost7','$waterrequired','$proteinrequired','$oilused','$fruittake','$nonveg','$milkintake','$coffee','$hungry','$gutaka','$sweets',$destress,'$diabetics','$medication','$healing','$program','$formula','$payment','$face','$chest','$waist','$hips','$larms','$rarms','$lthighs','$rthighs',$avail,'$rname1','$rname2','$rname3','$rname4','$rname5','$rname6','$rname7','$rname8','$rname9','$rname10','$rphone1','$rphone2','$rphone3','$rphone4','$rphone5','$rphone6','$rphone7','$rphone8','$rphone9','$rphone10','$rchallenge1','$rchallenge2','$rchallenge3','$rchallenge4','$rchallenge5','$rchallenge6','$rchallenge7','$rchallenge8','$rchallenge9','$rchallenge10','$rrelation1','$rrelation2','$rrelation3','$rrelation4','$rrelation5','$rrelation6','$rrelation7','$rrelation8','$rrelation9','$rrelation10')";
echo $str;
$rs=mysql_query($str);
//echo $rs;
if($rs)
{
?>
<script>
</script>
<?php }else
{
?>
<script>
alert ("Data is not sent");
</script>
<?php
}
?>
hi dani this is the 1st time i am dealing wid huge data base so plz help me
