$db_connection = new COM("ADODB.Connection"); $db_connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("../database.mdb") ." ;DefaultDir=". realpath("../"); $db_connection->open($db_connstr); $rs = $db_connection->execute("SELECT this, and_that FROM some_table"); $rs_fld0 = $rs->Fields(0); $rs_fld1 = $rs->Fields(1); while (!$rs->EOF) { /* do some stuff with the results to make it look nice on screen */ /* but as an example... */ print "$rs_fld0->value $rs_fld1->value\n"; $rs->MoveNext(); /* updates fields! */ } $rs->Close(); $db_connection->Close();