Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$db") or exit('Cannot open with Jet.'); //$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$db") or exit('Cannot open with driver.'); $sql = 'SELECT ProductName, QuantityPerUnit, UnitPrice FROM Products ORDER BY ProductName'; $rs = $conn->Execute($sql); ?>
Product Name | Quantity Per Unit | Unit Price |
---|---|---|
Fields['ProductName']->Value ?> | Fields['QuantityPerUnit']->Value ?> | Fields['UnitPrice']->Value ?> |