Im getting an error stating my query is incomplete. Im trying to insert my info into an access database. Im sure the connect file is fine, ive used it on another script. Im pretty sure its not the form because ive tested to make sure all of the variable print out okay. anyone see my error?
[Microsoft][ODBC Microsoft Access Driver] Syntax error in query. Incomplete query clause.
<?php
//Establishes connection to the access database
require_once('../../connect.php');
//Set check variable to the date
$check = $_POST['date'];
//Setting the username to a variable
$u = $_POST['username'];
//Set the times for each day into variables
$m = $_POST['m1'] . ' - ' . $_POST['m2'];
$t = $_POST['t1'] . ' - ' . $_POST['t2'];
$w = $_POST['w1'] . ' - ' . $_POST['w2'];
$tr = $_POST['tr1'] . ' - ' . $_POST['tr2'];
$f = $_POST['f1'] . ' - ' . $_POST['f2'];
$s = $_POST['s1'] . ' - ' . $_POST['s2'];
$su = $_POST['su1'] . ' - ' . $_POST['su2'];
//Check to see if a not has been added.
if($_POST['note'] == "You may write a note about any differences from your regular schedule."){
$n = NULL;
}else{
$n = $_POST['note'];
}
//Check for variables before run query
if($m && $t && $w && $tr && $f && $s && $su && $u){
//Run insert Query
$query = "INSERT INTO '$u' (date, monday, tuesday, wednesday, thursday, friday, saturday, sunday)
VALUES ('$check', '$m', '$t', '$w', '$tr', '$f', '$s', '$su')";
$result = odbc_exec($odbc, $query) or die (odbc_errormsg());
}
?>