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

Recommended Answers

check your database fields first.

Jump to Post

All 3 Replies

check database fields and check that your are closing the opened "(" next to values (can't find it on your code).

Ahh! Use code tags please! You problem is the first couple characters: ''1. The single-quote starts a string and ends a string, then you have a number after it. Did you mean: '1' or '', 1? Both of these are valid SQL, but to be sure, can we see the query that is causing the problem.
Edit
My bad, I was oblivious to the fact that the query was there (I should have noticed it though, because I mentioned the code tags.) I'm looking into your problem now.
---
The only thing I could think of its that one of the variables you are inserting contains ''1, which would produce an SQL error. Did you mysql_real_escape_string() all strings you are inserting?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.