0

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

Edited by Reverend Jim: Fixed formatting

4
Contributors
3
Replies
4
Views
7 Years
Discussion Span
Last Post by FlashCreations
0

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

0

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?

Edited by FlashCreations: n/a

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.