Hey I'm working with Access and I want to insert a record from form data submitted to the SQL page. See code:
$date = date("ydm");
odbc_autocommit($conn);
$Query="insert into jobs(jUID, jName, jDesc, jLocation, jStatus, jTSPost) VALUES('$jID', '$name', '$description', '$location', '$status', '$date');";
echo $Query;
$ret = odbc_exec($conn, $Query) or die("Invalid query : $Query");
The query executes on the page, it works when I run it as a query in Access, but the row is never inserted and I do not get an error in the browser. I'm weary of trying to figure this out. Please help any way you can.
