PHP connect DBF file update

I posted PHP connect DBF file with a sample. Now Pierre left the message and asked why error comes up.
I doing some tests and get the answer.
1) The database.dbf is reserved name.
2) The field name is always capital.

Let me give the better sample here.

$strsql= 'SELECT * FROM dat.dbf';
$query = odbc_exec($odbc, $strsql) or die (odbc_errormsg());
while($row = odbc_fetch_array($query))
echo 'Client Name: '.$row['NAME'].'
echo 'Client Phone Number: '.$row['PHONE'].'
echo '<hr />';
Tags:, ,