<?php
require 'adodb.inc.php';

$db = newADOConnection('mysql');
$db->Connect("server","user","pass","database");

$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
$result = $db->Execute("SELECT ... ")
  or die("query failed: ".$db->ErrorMsg());

while (!$result->EQF) {
  echo " {$result->fields[id]} ... ";
  $result->MoveNext();
}