Select a bunch of stuff and loop through it with associative arrays:

$DB->SetFetchMode(ADODB_FETCH_ASSOC);

$result = $DB->Execute($query) or die (“Query Failed”);

while ($myresult = $result->FetchRow())

Use only the first result or single row and access it with associate arrays:

$DB->SetFetchMode(ADODB_FETCH_ASSOC);

$result = $DB->Execute($query) or die (“Query Failed”);

$myresult = $result->fields;

Get a bunch of things and loop through it with numerical arrays:

$DB->SetFetchMode(ADODB_FETCH_NUM);

$result = $DB->Execute($query) or die (“Query Failed”);

while ($myresult = $result->FetchRow())

**Get a bunch of things and loop through it with numerical arrays:</p>

</b> $DB->SetFetchMode(ADODB_FETCH_NUM);

$result = $DB->Execute($query) or die (“Query Failed”);

$myresult = $result->fields;

Get the insert ID of the most recent thing that was inserted:

$myinsertid = $DB->Insert_ID();

Get the field’s name and type

$fields = $DB->MetaColumns($options_table_name);

foreach($fields as $v) {

echo “Name: $v->name “;

echo “Type: $v->type

“;

}

Find out if any rows were returned:

if (!$result   $result->RowCount()

Turn on the debug flag to see lots of ADODB verbose output:

$DB->debug = true;