Code: Select all
function today($DBdate){
$date = getdate();
$year = $dateї'year'];
$day=$dateї'weekday'];
$month=$dateї'month'];
$DBmonth=$dateї'mon'];
$numday=$dateї'mday'];
$calendar = iif($DBdate,"$DBmonth/$numday/$year" ,"$day, $month $numday $year", true);
return $calendar;
}Code: Select all
$getWO_id = "insert into workout_t (user_id, date) values (".$userID.", '".today(true)."') ";
$insertted = odbc_exec($dbObj, $getWO_id);Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement., SQL state 37000 in SQLExecDirect in C:\apache\htdocs\insert_sets.php on line 14
insert into workout_t (user_id, date) values (10, '12/3/2003')
Can anyone think of anything why this would be happening???