<?php
require 'metabase_interface.php';
require 'metabase_database.php';

$error = MetabaseSetupDatabase(
  array("Type"=>"mysql","User"=>"user","Password"=>"pass"),
  $database
) and die("unable to connect: $error");

$stmt = MetabasePreparedQuery($database, "SELECT ... ");
$result = MetabaseExecuteQuery($database, $stmt)
  or die("query failed: ".MetabaseError($database));

$rows = MetabaseNumberOfRows($database, $result);
for ($row = 0; $row < $rows; $row++) {
  $id = MetabaseFetchResult($database, $result, $row, "id");
  echo " $id ... ";
}