Re: [mdb-dev] PHP and ODBC leaving lots of files open

[Mike P. <mj...@fi...>]

Hi Chris,

Thanks for the hint.....but to no avail, sadly.

Here's the code in case anyone can spot my stupidity:-

function getClientName($s)
{
    $myDB = odbc_connect("Clients", "", "");
    $query = "select Name from Clients where ID = '".$s."'";
    $result = odbc_exec($myDB, $query);

    if (odbc_fetch_row($result))
       $retval = odbc_result($result, 'Name');
    else
       $retval = "Unknown";

    odbc_commit($myDB);
    odbc_close($myDB);
    return $retval;
}

Running this leaves my clients.mdb file open by the apache process 
according to lsof -ap.

Puzzling....

-- 

Cheers,

Mike

mj...@fi...                                 http://www.filmsat59.com
Films at 59 Ltd, 59 Cotham Hill, Bristol. BS6 6JR ENGLAND +44 117 906 4300