php 4 and ms access 2000

[knowledg3]

I am able to insert into my access database but for some reason my update statements aren't working and I am not getting any errors.

$WindowsDate = date("n/j/Y",mktime(0,0,0,date("n"),date("j"),date("Y"))); / Set Variables to POST values /
$TicketN = $POST['TicketNumber'];
$UserN = $POST['UserName'];
$Resolution = $POST['Resolution'];
$TimeRes = $POST['TimeResolved'];

$sql = "UPDATE Event SET EventResolution = '$Resolution' WHERE EventNo = 1001";
echo $sql;

$conn->Execute($sql);

[barand]

It all looks OK. Depends what's happening inside your $conn object. Perhaps the class is suppressing error reporting.

btw
$WindowsDate = date("n/j/Y") ;
would suffice - it defaults to current date/time.

[knowledg3]

thanks. i figured it out. i wasn't closing the database.