this code works if I take out the checkbox(repair & replace). otherwise I get a syntax error message pointing to the INSERT statement

<form name="form" action="<?php $_SERVER[PHP_SELF] ?>" method="post">
<input type="text" size="2" name="apt" id="apt" 
onkeyup="getResults();if(this.value.length==this.size)document.form.datereceived.focus();" />Apt

<input type="text" size="25" name="name" id="name" />Name

<INPUT TYPE="text" size=10 name="datereceived" 
onKeyUp="if(this.value.length==this.size)document.form.time.focus();">Date Received

<INPUT TYPE="text" size=7 name="time">Time Received


<br>Kitchen
<select name="item">
<option value="kitchen blinds" selected>kitchen blinds</option>
<option value="kitchen bifolds">kitchen bifolds</option>
<option value="kitchen lights">kitchen light fixtures</option>
<option value="kitchen bulbs">kitchen light bulbs</option>
<option value="kitchen tile">kitchen tile/linoleum</option>
<option value="kitchen countop">kitchen counter top</option>
<option value="kitchen cabinets">kitchen cabinets</option>
<option value="kitchen drawers">kitchen drawers</option>
<option value="fridge">refidgerator</option>
<option value="stove">stove</option>
<option value="range hood">stove hood</option>
<option value="kitchen sink">kitchen sink</option>
<option value="under kitchensink">under kitchen sink</option>
<option value="kitchen faucet">kitchen faucet</option>
<option value="kitchen drain">kitchen drain</option>
<option value="kitchen screens">kitchen windows & screens</option>
<option value="fire extinguisher">fire extinguisher</option>
<option value="kitchen wall plates">kitchen switch plates</option>
<option value="kitchen outlets">kitchen electrical outlets</option>
<option value="kitchen ceilings">kitchen ceiling paint</option>
<option value="kitchen wallpaint">kitchen wall paint</option>
</select>
<br> repaired <input type=checkbox name="repair" value="Y">
 replaced <input type=checkbox name="replace" value="Y"><br>
</p>
action<INPUT TYPE="text" size=100 name="action">

<INPUT TYPE="text" size=2 name="compday" MAXLENGTH=2 
onKeyUp="if(this.value.length==this.size)document.form.compmoyr.focus();">
<INPUT TYPE="text" size=7 name="compmoyr" MAXLENGTH=7 
Date Completed - <font color=red>day then mm/yyyy</font 


 cost<INPUT TYPE="text" size=4 name="cost">
 charge<INPUT TYPE="text" size=4 name="charge"> 
Order#<INPUT TYPE="text" size=4 name="ordno"> -  If Insp
<p>
<INPUT type="submit" value="submit data" />
</p>
</form>

<?php
if (isset( $_POST['apt']) ) {
$apt=$_POST['apt'];  
$name=$_POST['name'];  
$datereceived=$_POST['datereceived'];  
$time=$_POST['time'];  
$item=$_POST['item'];
$repair=$_POST['repair'];  
$replace=$_POST['replace'];
$action=$_POST['action'];  
$compday=$_POST['compday'];  
$compmoyr=$_POST['compmoyr'];  
$cost=$_POST['cost'];  
$charge=$_POST['charge'];  
$ordno=$_POST['ordno'];
$stat = mysql_connect("localhost","root","" or die('Unable to connect to database: ' . mysql_error());  
$stat = mysql_select_db("maintdb" or die('Unable to select database: ' . mysql_error());  
$query = "
INSERT INTO maintdata (apt,name,datereceived,time,item,repair,replace,action,compday,compmoyr,cost,charge,ordno)
VALUES('$apt','$name','$datereceived','$time','$item','$repair','$replace','$action','$compday','$compmoyr','$cost','$charge','$ordno')";
echo "apt $apt data inserted</font>

"; 
$stat = mysql_query($query) or die('Query failed: ' . mysql_error());  
mysql_close();
}
?>

DUDE!
YOU HAVEN'T EVEN SOLVED YOUR LAST PROBLEM AND OFF YOU ARE AGAIN CREATING ANOTHER.
COMMON, LET'S TAKLE EM AS THEY COME!

OR HAVE YOU CHANGED THE SCRIPT FROM THE OLD ONE TO THIS ?

I ASKED WHAT YOU WANTED TO DO BUT IT SEEMS I GET BLANKS ALL THE TIME

MAYBE I WOULDA GIVEN YOU THE SCRIPT TO SLOVE YOUR PROBLEM. BUT SINCE I DO NOT KNOW[i] WHAT[/i] YOU INTEND TO DO IN THE SCRIPT HMM, I WILL REST MY CASE FOR NOW.

sorry sweet, this is an entirely different program.