sql insert into error

davanderbilt

<?php
$error_rep=0;
?>

<?php
//I created this if statement to check for values only in these fields.  The other fields on the form are not required
//echo '<br><table><tr><td><b>';
if ((!$address) || (!$city) || (!$state) || (!$zip) || (!$Gender) || (!$age) || (!$DOB) || (!$Citizen) || (!$ethnicity) || (!$race) || (!$srweight) || (!$srheightft) || (!$srheightin) || (!$program) || (!$heartattack) || (!$angina) || (!$irregheart) || (!$otherheart) || (!$stroke) || (!$fainting) || (!$hbp) || (!$chol) || (!$thyroid) || (!$cancer) || (!$kidney) || (!$liver) || (!$gout) || (!$diabetes) || (!$psych) || (!$drug) || (!$eating) || (!$other) || (!$surgery) || (!$xrays) || (!$ct) || (!$pet) || (!$fluroscopic) || (!$nms) || (!$wtlossgain) || (!$exercise) || (!$Medication) || (!$supplement) || (!$alcohol) || (!$alcoholwkend) || (!$cigarettes) || (!$pipe) || (!$cigars) || (!$dip))
{
  $error_rep=1;	
  Print "You forgot to fill in some of the fields. Please go back and check your data.";

} else {
  $error_rep=0;
}	
//echo '</td></tr></table></b>';
$Name1=isset($HTTP_POST_VARS['Name1']) ? $HTTP_POST_VARS['Name1'] : 'NA';
$Name2=isset($HTTP_POST_VARS['Name2'])?$HTTP_POST_VARS['Name2']:'NA';
$address=isset($HTTP_POST_VARS['address']) ? $HTTP_POST_VARS['address'] :'NA';
$city=isset($HTTP_POST_VARS['city']) ? $HTTP_POST_VARS['city'] :'NA';
$state=isset($HTTP_POST_VARS['state']) ? $HTTP_POST_VARS['state'] :'NA';
$zip=isset($HTTP_POST_VARS['zip']) ? $HTTP_POST_VARS['zip'] : 0;
$Gender=isset($HTTP_POST_VARS['Gender']) ? $HTTP_POST_VARS['Gender'] :'NA';
$age=isset($HTTP_POST_VARS['age']) ? $HTTP_POST_VARS['age'] : 0;
$DOB=isset($HTTP_POST_VARS['DOB']) ? $HTTP_POST_VARS['DOB'] :'00/00/0000';
$Citizen=isset($HTTP_POST_VARS['Citizen']) ? $HTTP_POST_VARS['Citizen']:'NA';
$visa=isset($HTTP_POST_VARS['visa']) ? $HTTP_POST_VARS['visa'] : ' ';
$residence=isset($HTTP_POST_VARS['residence']) ? $HTTP_POST_VARS['residence'] : ' ';
$alien=isset($HTTP_POST_VARS['alien']) ? $HTTP_POST_VARS['alien'] :'NA';
$ethnicity=isset($HTTP_POST_VARS['ethnicity']) ? $HTTP_POST_VARS['ethnicity'] :'NA';
$race=isset($HTTP_POST_VARS['race']) ? $HTTP_POST_VARS['race'] :'NA';
$srweight=isset($HTTP_POST_VARS['srweight']) ? $HTTP_POST_VARS['srweight'] : 0;
$srheightft=isset($HTTP_POST_VARS['srheightft']) ? $HTTP_POST_VARS['srheightft'] : 0;
$srheightin=isset($HTTP_POST_VARS['srheightin']) ? $HTTP_POST_VARS['srheightin'] : 0;
$program=isset($HTTP_POST_VARS['program']) ? $HTTP_POST_VARS['program'] :'NA';
$other=isset($HTTP_POST_VARS['other']) ? $HTTP_POST_VARS['other'] : ' ';
$heartattack=isset($HTTP_POST_VARS['heartattack']) ? $HTTP_POST_VARS['heartattack'] :'NA';
$angina=isset($HTTP_POST_VARS['ggt']) ? $HTTP_POST_VARS['ggt'] :'NA';
$irregheart=isset($HTTP_POST_VARS['irregheart']) ? $HTTP_POST_VARS['irregheart'] :'NA';
$otherheart=isset($HTTP_POST_VARS['otherheart']) ? $HTTP_POST_VARS['otherheart'] :'NA';
$stroke=isset($HTTP_POST_VARS['stroke']) ? $HTTP_POST_VARS['stroke'] :'NA';
$fainting=isset($HTTP_POST_VARS['fainting']) ? $HTTP_POST_VARS['fainting'] :'NA';
$hbp=isset($HTTP_POST_VARS['hbp']) ? $HTTP_POST_VARS['hbp'] :'NA';
$chol=isset($HTTP_POST_VARS['chol']) ? $HTTP_POST_VARS['chol'] :'NA';
$thyroid=isset($HTTP_POST_VARS['thyroid']) ? $HTTP_POST_VARS['thyroid'] :'NA';
$cancer=isset($HTTP_POST_VARS['cancer']) ? $HTTP_POST_VARS['cancer'] :'NA';
$kidney=isset($HTTP_POST_VARS['kidney']) ? $HTTP_POST_VARS['kidney'] :'NA';
$liver=isset($HTTP_POST_VARS['liver']) ? $HTTP_POST_VARS['liver'] :'NA';
$gout=isset($HTTP_POST_VARS['gout']) ? $HTTP_POST_VARS['gout'] :'NA';
$diabetes=isset($HTTP_POST_VARS['diabetes']) ? $HTTP_POST_VARS['diabetes'] :'NA';
$psych=isset($HTTP_POST_VARS['psych']) ? $HTTP_POST_VARS['psych'] :'NA';
$drug=isset($HTTP_POST_VARS['drug']) ? $HTTP_POST_VARS['drug'] :'NA';
$eating=isset($HTTP_POST_VARS['eating']) ? $HTTP_POST_VARS['eating'] :'NA';
$other=isset($HTTP_POST_VARS['other']) ? $HTTP_POST_VARS['other'] :'NA';
$surgery=isset($HTTP_POST_VARS['surgery']) ? $HTTP_POST_VARS['surgery'] :'NA';
$xrays=isset($HTTP_POST_VARS['xrays']) ? $HTTP_POST_VARS['xrays'] :'NA';
$ct=isset($HTTP_POST_VARS['ct']) ? $HTTP_POST_VARS['ct'] :'NA';
$pet=isset($HTTP_POST_VARS['pet']) ? $HTTP_POST_VARS['pet'] :'NA';
$fluroscopic=isset($HTTP_POST_VARS['fluroscopic']) ? $HTTP_POST_VARS['fluroscopic'] :'NA';
$nms=isset($HTTP_POST_VARS['nms']) ? $HTTP_POST_VARS['nms'] :'NA';
$wtlossgain=isset($HTTP_POST_VARS['wtlossgain']) ? $HTTP_POST_VARS['wtlossgain'] :'NA';
$wtlbs=isset($HTTP_POST_VARS['wtlbs']) ? $HTTP_POST_VARS['wtlbs'] : 0;
$gainloss=isset($HTTP_POST_VARS['gainloss']) ? $HTTP_POST_VARS['gainloss'] :'NA';
$exercise=isset($HTTP_POST_VARS['exercise']) ? $HTTP_POST_VARS['exercise'] :'NA';
$Medication=isset($HTTP_POST_VARS['Medication']) ? $HTTP_POST_VARS['Medication'] :'NA';
$supplement=isset($HTTP_POST_VARS['supplement']) ? $HTTP_POST_VARS['supplement'] :'NA';
$alcohol=isset($HTTP_POST_VARS['alcohol']) ? $HTTP_POST_VARS['alcohol'] :'NA';
$drinkswkday=isset($HTTP_POST_VARS['drinkswkday']) ? $HTTP_POST_VARS['drinkswkday'] : 0;
$alcoholwkend=isset($HTTP_POST_VARS['alcoholwkend']) ? $HTTP_POST_VARS['alcoholwkend'] :'NA';
$drinkswkend=isset($HTTP_POST_VARS['drinkswkend']) ? $HTTP_POST_VARS['drinkswkend'] : 0;
$cigarettes=isset($HTTP_POST_VARS['cigarettes']) ? $HTTP_POST_VARS['cigarettes'] :'NA';
$cigarettesdesc=isset($HTTP_POST_VARS['cigarettesdesc']) ? $HTTP_POST_VARS['cigarettesdesc'] :'NA';
$pipe=isset($HTTP_POST_VARS['pipe']) ? $HTTP_POST_VARS['pipe'] :'NA';
$pipedesc=isset($HTTP_POST_VARS['pipedesc']) ? $HTTP_POST_VARS['pipedesc'] :'NA';
$cigars=isset($HTTP_POST_VARS['cigars']) ? $HTTP_POST_VARS['cigars'] :'NA';
$cigarsdesc=isset($HTTP_POST_VARS['cigarsdesc']) ? $HTTP_POST_VARS['cigarsdesc'] :'NA';
$dip=isset($HTTP_POST_VARS['dip']) ? $HTTP_POST_VARS['dip'] :'NA';
$dipdesc=isset($HTTP_POST_VARS['dipdesc']) ? $HTTP_POST_VARS['dipdesc'] :'NA';

$conn = odbc_connect ('LTE_Master', '', '');
 $get_stat = "SELECT patientid from [Official_Name_and_Status] where FNAME = '$Name1' and LNAME = '$Name2';";
  $id= odbc_exec($conn,$get_stat);

  $case_number = odbc_result($id, 1);
  $case_number = $case_number ? $case_number : 0; 
  $case_number=(integer)$case_number;

$insert_statement = "
	insert into 
		[Health_History]
		values	 ($case_number,'$Name1','$Name2','$address','$city','$state','$zip',$Gender,$age,$DOB,$Citizen,'$visa','$residence',$alien,$ethnicity,$race,$srweight,$srheightft,$srheightin,$program,'$other',$heartattack,$angina,$irregheart,$otherheart,$stroke,$fainting,$hbp,$chol,$thyroid,$cancer,$kidney,$liver,$gout,$diabetes,$psych,$drug,$eating,$other,$surgery,$xrays,$ct,$pet,$fluroscopic,$nms,$wtlossgain,$wtlbs,$gainloss,$exercise,$Medication,$supplement,$alcohol,$drinkswkday,$alcoholwkend,$drinkswkend,$cigarettes,'$cigarettesdesc',$pipe,'$pipedesc',$cigars,'$cigarsdesc',$dip,'$dipdesc')";

$result= odbc_exec($conn,$insert_statement);
if($result)
{ //this is the line giving the SQL Error

?>
<table width="698" border="0">
  <tr>
    <td width="688" height="51" bordercolor="#FFFFFF"><h4><font color="#0000FF" size="+4"><em><font color="#006699" size="+3">Your</font> <font color="#006699" size="+3">data has been submitted successfully! </font></em></font></h4>
      <p><span class="style18">Click <a href="javascript:history.back()">here</a> to go back</span></p></td>
  </tr>
</table>
<h3 align="justify"><font color="#0000FF" size="+4"> </font>

<?php
}
include ("footer.php");
?>
</h3>

When I submit I get the following error:

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement., SQL state 37000 in SQLExecDirect in c:\program files\apache group\apache\htdocs\lte\hh_add2.php on line 254

I just need to have the variables pushed into the Health_History table in an Access database, as referenced by the odbc_connect statement. Is there a simpler way to do this?
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement., SQL state 37000 in SQLExecDirect in c:\program files\apache group\apache\htdocs\lte\hh_add2.php on line 254

I just need to have the variables pushed into the Health_History table in an Access database, as referenced by the odbc_connect statement. Is there a simpler way to do this?

NogDog

You might want to try something like this to get some more debug info:

$result= odbc_exec($conn,$insert_statement) or
      die("Insert failed ($insert_statment): " . odbc_error());

This will let you see the exact query string that was sent to the DBMS, so you can check for missing data, values that should have been quoted, etc.

davanderbilt

I added that line for debugging and now it says

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement., SQL state 37000 in SQLExecDirect in c:\program files\apache group\apache\htdocs\lte\hh_add2.php on line 252
Insert failed (): 37000

That is a syntax or access violation error

NogDog

If you copied-and-pasted my code, it looks like I left out an "e", thus there was nothing in the parentheses after the "insert failed":

. . . die("Insert failed ($insert_stat[color=red][b]e[/b][/color]ment): . . .

See if that at least shows the query now so we can see what might be wrong/missing.

davanderbilt

I added the 'e'. Oops, I just didn't catch that. 🙂 That was very helpful, but it shows that the data passed thru just as I typed it in, still giving the same SQL error.

NogDog

Does the database user you're connecting with have insert privilege on that database and table? (I may be grasping at straws here, just trying to think of anything that might cause that error.)

bradgrafelman

Any chance you can copy and paste the outputted query for us to inspect?

davanderbilt

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement., SQL state 37000 in SQLExecDirect in c:\program files\apache group\apache\htdocs\lte\hh_add2.php on line 252
Insert failed ( insert into Health_History(case_number,Name1,Name2,address,city,state,zip,dorm,room,
homephone,schoolphone,workphone,cellphone,email1,email2,Gender,age,DOB,
Citizen,visa,residence,alien,ethnicity,race,srweight,srheightft,srheightin,program,
other,heartattack,heartattackdod,heartattackdesc,angina,anginadod,anginadesc,
irregheart,irregheartdod,irregheartdesc,otherheart,otherheartdod,otherheartdesc,
stroke,strokedod,strokedesc,fainting,faintingdod,faintingdesc,hbp,hbpdod,hbpdesc,
chol,choldod,choldesc,thyroid,thyroiddod,thyroiddesc,cancer,cancerdod,cancerdesc,
kidney,kidneydod,kidneydesc,liver,liverdod,liverdesc,gout,goutdod,goutdesc,diabetes,
diabetesdod,diabetesdesc,psych,psychdod,psychdesc,drug,drugdod,drugdesc,
eating,eatingdod,eatingdesc,other,otherdod,otherdesc,surgery,surgerydesc,xrays,
xraynum,ct,pet,fluroscopic,nms,wtlossgain,wtlbs,gainloss,exercise,activity1,
act1dur,act1days,activity2,act2dur,act2days,activity3,act3dur,act3days,activity4,
act4dur,act4days,Medication,Med1,Med1reason,Med2,Med2reason,Med3,Med3reason,
supplement,supplement1,supplement1reason,supplement2,supplement2reason,
supplement3,supplement3reason,alcohol,drinkswkday,alcoholwkend,drinkswkend,
cigarettes,cigarettesdesc,pipe,pipedesc,cigars,cigarsdesc,dip,dipdesc,pregnant,
werepregnant,planpregnant,hysterectomy,period,noperiod,lastperiod) values(101,'Joe','Smith','123 Spruce Street ','Lawrence','KS','66045','Naismith Hall','500B','7858168854','7858168854','','7858168854','email@gmail.com','',1,
22,05/29/81,1,'','', ,2,5,150,5,2.5,1,'2',2,,'',2,,'',2,,'',2,,'',2,,'',2,,'',2,,'',2,,'',2,,'',2,,'',2,,'',2,,'',2,,'',2,,'',2,,'',2,,'',
2,,'',2,,'',2,'',2,,2,2,2,2,2,, ,2,'',,,'',,,'',,,'',,,2,'','','','','','',2,'','','','','','',0,,0,,2,'',2,'',2,'',2,'', , , , , ,'',)): 37000

davanderbilt

the user has insert privileges for this table and database

bradgrafelman

I'm no expert in this SQL language, but a couple of general questions:

Is it allowable to have data such as 05/29/81 be passed as a non-string type? What I mean is, in your query, you do not have this date surrounded by quotes. Is this correct? Try surrounding this value in quotes, perhaps?
A lot of the values are simply skipped (e.g. "2, '',,,'',,,'',,," and so on) without providing a null value ( '' ) or anything. Is this correct? Should you not supply null strings (e.g. two quotes - '') instead?

Also, instead of using [man]odbc_error/man, perhaps [man]odbc_errormsg/man might give us more information?

davanderbilt

Thank you for catching the dates! You're right they were supposed to be quoted, so I fixed that. The empty values were for fields that have a numeric or date format, which is why I didn't pass through a null like the text values. Unfortunately neither of these things fixed the error.

davanderbilt

I decided to try another route and just make none of the fields required, but now get a SQL Data Type Mismatch error. If I type something in for each date field, the data does go into the database, but not all of these fields are required for every person. This error must be related to date fields, because if I leave the text fields blank, it goes into the DB just fine, but when I don't have a value for a field that is specified in Access as date/time it won't go in.

<?php
echo '<br><table><tr><td><b>';
foreach ($HTTP_POST_VARS as $key => $value) {
$temp = stripslashes($value);
$HTTP_POST_VARS[$key] = $temp;
}
echo '</td></tr></table></b>';

$Name1=isset($HTTP_POST_VARS['Name1']) ? $HTTP_POST_VARS['Name1'] : 'NA';
$Name2=isset($HTTP_POST_VARS['Name2'])?$HTTP_POST_VARS['Name2']:'NA';
$address=isset($HTTP_POST_VARS['address']) ? $HTTP_POST_VARS['address'] :'NA';
$city=isset($HTTP_POST_VARS['city']) ? $HTTP_POST_VARS['city'] :'NA';
$state=isset($HTTP_POST_VARS['state']) ? $HTTP_POST_VARS['state'] :'NA';
$zip=isset($HTTP_POST_VARS['zip']) ? $HTTP_POST_VARS['zip'] : 0;
$Gender=isset($HTTP_POST_VARS['Gender']) ? $HTTP_POST_VARS['Gender'] :'NA';
$age=isset($HTTP_POST_VARS['age']) ? $HTTP_POST_VARS['age'] : 0;
$DOB=isset($HTTP_POST_VARS['DOB']) ? $HTTP_POST_VARS['DOB'] :'00/00/0000';
$Citizen=isset($HTTP_POST_VARS['Citizen']) ? $HTTP_POST_VARS['Citizen']:'NA';
$visa=isset($HTTP_POST_VARS['visa']) ? $HTTP_POST_VARS['visa'] : ' ';
$residence=isset($HTTP_POST_VARS['residence']) ? $HTTP_POST_VARS['residence'] : ' ';
$alien=isset($HTTP_POST_VARS['alien']) ? $HTTP_POST_VARS['alien'] :'NA';
$ethnicity=isset($HTTP_POST_VARS['ethnicity']) ? $HTTP_POST_VARS['ethnicity'] :'NA';
$race=isset($HTTP_POST_VARS['race']) ? $HTTP_POST_VARS['race'] :'NA';
$srweight=isset($HTTP_POST_VARS['srweight']) ? $HTTP_POST_VARS['srweight'] : 0;
$srheightft=isset($HTTP_POST_VARS['srheightft']) ? $HTTP_POST_VARS['srheightft'] : 0;
$srheightin=isset($HTTP_POST_VARS['srheightin']) ? $HTTP_POST_VARS['srheightin'] : 0;
$program=isset($HTTP_POST_VARS['program']) ? $HTTP_POST_VARS['program'] :'NA';
$other=isset($HTTP_POST_VARS['other']) ? $HTTP_POST_VARS['other'] : 'NA';
$heartattack=isset($HTTP_POST_VARS['heartattack']) ? $HTTP_POST_VARS['heartattack'] :'NA';
$heartattackdod=isset($HTTP_POST_VARS['heartattackdod']) ? $HTTP_POST_VARS['heartattackdod'] :'00/00/0000';
$angina=isset($HTTP_POST_VARS['angina']) ? $HTTP_POST_VARS['angina'] :'NA';
$anginadod=isset($HTTP_POST_VARS['anginadod']) ? $HTTP_POST_VARS['anginadod'] :'00/00/0000';
$stroke=isset($HTTP_POST_VARS['stroke']) ? $HTTP_POST_VARS['stroke'] :'NA';
$strokedod=isset($HTTP_POST_VARS['strokedod']) ? $HTTP_POST_VARS['strokedod'] :'00/00/0000';
$cancer=isset($HTTP_POST_VARS['cancer']) ? $HTTP_POST_VARS['cancer'] :'NA';
$cancerdod=isset($HTTP_POST_VARS['cancerdod']) ? $HTTP_POST_VARS['cancerdod'] :'00/00/0000';
$gout=isset($HTTP_POST_VARS['gout']) ? $HTTP_POST_VARS['gout'] :'NA';
$goutdod=isset($HTTP_POST_VARS['goutdod']) ? $HTTP_POST_VARS['goutdod'] :'00/00/0000';
$diabetes=isset($HTTP_POST_VARS['diabetes']) ? $HTTP_POST_VARS['diabetes'] :'NA';
$diabetesdod=isset($HTTP_POST_VARS['diabetesdod']) ? $HTTP_POST_VARS['diabetesdod'] :'00/00/0000';
$surgery=isset($HTTP_POST_VARS['surgery']) ? $HTTP_POST_VARS['surgery'] :'NA';
$xrays=isset($HTTP_POST_VARS['xrays']) ? $HTTP_POST_VARS['xrays'] :'NA';
$xraynum=isset($HTTP_POST_VARS['xraynum']) ? $HTTP_POST_VARS['xraynum'] : 0;
$ct=isset($HTTP_POST_VARS['ct']) ? $HTTP_POST_VARS['ct'] :'NA';
$pet=isset($HTTP_POST_VARS['pet']) ? $HTTP_POST_VARS['pet'] :'NA';
$fluroscopic=isset($HTTP_POST_VARS['fluroscopic']) ? $HTTP_POST_VARS['fluroscopic'] :'NA';
$nms=isset($HTTP_POST_VARS['nms']) ? $HTTP_POST_VARS['nms'] :'NA';
$wtlossgain=isset($HTTP_POST_VARS['wtlossgain']) ? $HTTP_POST_VARS['wtlossgain'] :'NA';
$wtlbs=isset($HTTP_POST_VARS['wtlbs']) ? $HTTP_POST_VARS['wtlbs'] : 0;
$gainloss=isset($HTTP_POST_VARS['gainloss']) ? $HTTP_POST_VARS['gainloss'] :'NA';
$exercise=isset($HTTP_POST_VARS['exercise']) ? $HTTP_POST_VARS['exercise'] :'NA';
$Medication=isset($HTTP_POST_VARS['Medication']) ? $HTTP_POST_VARS['Medication'] :'NA';
$supplements=isset($HTTP_POST_VARS['supplements']) ? $HTTP_POST_VARS['supplements'] :'NA';
$alcohol=isset($HTTP_POST_VARS['alcohol']) ? $HTTP_POST_VARS['alcohol'] :'NA';
$drinkswkday=isset($HTTP_POST_VARS['drinkswkday']) ? $HTTP_POST_VARS['drinkswkday'] : 0;
$alcoholwkend=isset($HTTP_POST_VARS['alcoholwkend']) ? $HTTP_POST_VARS['alcoholwkend'] :'NA';
$drinkswkend=isset($HTTP_POST_VARS['drinkswkend']) ? $HTTP_POST_VARS['drinkswkend'] : 0;
$cigarettes=isset($HTTP_POST_VARS['cigarettes']) ? $HTTP_POST_VARS['cigarettes'] :'NA';
$cigarettesdesc=isset($HTTP_POST_VARS['cigarettesdesc']) ? $HTTP_POST_VARS['cigarettesdesc'] :'NA';
$pipe=isset($HTTP_POST_VARS['pipe']) ? $HTTP_POST_VARS['pipe'] :'NA';
$pipedesc=isset($HTTP_POST_VARS['pipedesc']) ? $HTTP_POST_VARS['pipedesc'] :'NA';
$cigars=isset($HTTP_POST_VARS['cigars']) ? $HTTP_POST_VARS['cigars'] :'NA';
$cigarsdesc=isset($HTTP_POST_VARS['cigarsdesc']) ? $HTTP_POST_VARS['cigarsdesc'] :'NA';
$dip=isset($HTTP_POST_VARS['dip']) ? $HTTP_POST_VARS['dip'] :'NA';
$dipdesc=isset($HTTP_POST_VARS['dipdesc']) ? $HTTP_POST_VARS['dipdesc'] :'NA';
$pregnant=isset($HTTP_POST_VARS['pregnant']) ? $HTTP_POST_VARS['pregnant'] :'NA';
$werepregnant=isset($HTTP_POST_VARS['werepregnant']) ? $HTTP_POST_VARS['werepregnant'] :'NA';
$planpregnant=isset($HTTP_POST_VARS['planpregnant']) ? $HTTP_POST_VARS['planpregnant'] :'NA';
$hysterectomy=isset($HTTP_POST_VARS['hysterectomy']) ? $HTTP_POST_VARS['hysterectomy'] :'NA';
$period=isset($HTTP_POST_VARS['period']) ? $HTTP_POST_VARS['period'] :'NA';
$noperiod=isset($HTTP_POST_VARS['noperiod']) ? $HTTP_POST_VARS['noperiod'] :'NA';
$lastperiod=isset($HTTP_POST_VARS['lastperiod']) ? $HTTP_POST_VARS['lastperiod'] :'00/00/0000';
$enter=isset($HTTP_POST_VARS['enter'])? $HTTP_POST_VARS['enter'] : 'NA';
$reviewed=isset($HTTP_POST_VARS['reviewed'])?$HTTP_POST_VARS['reviewed']:'NA';

$conn = odbc_connect ('LTE_Master', '', '');
 $get_stat = "SELECT patientid from [Official_Name_and_Status] where FNAME = '$Name1' and LNAME = '$Name2';";
  $id= odbc_exec($conn,$get_stat);

  $case_number = odbc_result($id, 1);
  $case_number = $case_number ? $case_number : 0; 
  $case_number=(integer)$case_number;

$insert_statement = "
	insert into 
		[Health_History]
		values	 ($case_number,'$Name1','$Name2','$address','$city','$state','$zip','$dorm','$room','$homephone','$schoolphone','$workphone','$cellphone','$email1','$email2',$Gender,$age,'$DOB',$Citizen,'$visa','$residence',$alien,$ethnicity,$race,$srweight,$srheightft,$srheightin,$program,'$other',$heartattack,'$heartattackdod','$heartattackdesc',$angina,'$anginadod','$anginadesc',$irregheart,'$irregheartdod','$irregheartdesc',$otherheart,'$otherheartdod','$otherheartdesc',$stroke,'$strokedod','$strokedesc',$fainting,'$faintingdod','$faintingdesc',$hbp,'$hbpdod','$hbpdesc',$chol,'$choldod','$choldesc',$thyroid,'$thyroiddod','$thyroiddesc',$cancer,'$cancerdod','$cancerdesc',$kidney,'$kidneydod','$kidneydesc',$liver,'$liverdod','$liverdesc',$gout,'$goutdod','$goutdesc',$diabetes,'$diabetesdod','$diabetesdesc',$psych,'$psychdod','$psychdesc',$drug,'$drugdod','$drugdesc',$eating,'$eatingdod','$eatingdesc',$other,'$otherdod','$otherdesc',$surgery,'$surgerydesc',$xrays,$xraynum,$ct,$pet,$fluroscopic,$nms,$wtlossgain,$wtlbs,$gainloss,$exercise,'$activity1',$act1dur,$act1days,'$activity2',$act2dur,$act2days,'$activity3',$act3dur,$act3days,'$activity4',$act4dur,$act4days,$Medication,'$Med1','$Med1reason','$Med2','$Med2reason','$Med3','$Med3reason',$supplements,'$supplement1','$supplement1reason','$supplement2','$supplement2reason','$supplement3','$supplement3reason',$alcohol,$drinkswkday,$alcoholwkend,$drinkswkend,$cigarettes,'$cigarettesdesc',$pipe,'$pipedesc',$cigars,'$cigarsdesc',$dip,'$dipdesc',$pregnant,$werepregnant,$planpregnant,$hysterectomy,$period,'$noperiod','$lastperiod','$enter','$reviewed')";

$result = odbc_exec($conn,$insert_statement); //SQL error 37000 on this line

if(!$result)
{
  echo 'There has been error while submitting your survey. ';
?>
</p>
<?php
}
elseif ($result)
{
?>
<table width="698" border="0">
  <tr>
    <td width="688" height="51" bordercolor="#FFFFFF"><h4><font color="#0000FF" size="+4"><em><font color="#006699" size="+3">Your</font> <font color="#006699" size="+3">data has been submitted successfully! </font></em></font></h4>
      <p><span class="style18">Click <a href="javascript:history.back()">here</a> to go back</span></p></td>
  </tr>
</table>
<h3 align="justify"><font color="#0000FF" size="+4"> </font>
  <?php


}

else 
{
	?>
  <table width="698" border="0">
  <tr>
    <td width="688" height="70" bordercolor="#FFFFFF"><p><font color="#0000FF" size="+4"><em><font color="#006699" size="+3">All the fields have not been filled.</font></em></font></p>
    <p><font color="#0000FF" size="+4"><em><font color="#006699" size="+3">Please fill them.</font></em></font><?php echo '&nbsp;&nbsp;<a href = "javascript:history.back();">Click Here to Go Back</a>'; ?></p></td>
  </tr>
</table>
<h3 align="justify"><font color="#0000FF" size="+4"> </font>
<?php
}
include ("footer.php");
?>
</h3>

If date field isn't filled in:

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria 
expression., SQL state 22005 in SQLExecDirect in c:\program files\apache group\apache\htdocs
\lte\hh_add.php on line 269
There has been error while submitting your survey.

Line 269 is:

$result = odbc_exec($conn,$insert_statement);

At least I'm making some progress. 🙂

ClarkF1

What is the field type of the date of birth field?

davanderbilt

date/time with a short date format (mm/dd/yyyy)