2,
'portability' => DB_PORTABILITY_ALL,
);
$db = &db::connect($dsn, $options);
if (pear::isError($db)) {
die($db->getMessage());
}
else {
$db->setFetchMode(DB_FETCHMODE_ASSOC);
$st = $db->prepare("select counter_id,hits from blog.counters where hits>=?");
$rs = &$db->execute($st, array(40));
if (pear::isError($rs)) {
die($rs->getMessage());
}
else {
//if ($rs->numRows > 0)
echo " \n";
while ($rs->fetchInto($row)) {
echo " | ".$row['counter_id']." | ".$row['hits']." |
\n";
}
//if ($rs->numRows > 0)
echo "
\n";
}
$db->disconnect();
}
?>