function listAllVersion()
{
$db = new objDBSQL();
$db->statement = "\n SELECT SITE_HOST_NAME,VERSION_DATE_TIME,VERSION_ID\n FROM SITE\n LEFT JOIN VERSION ON VERSION_SITE_ID=SITE_ID\n\n ";
$db->execute();
$ret = array();
while ($r = $db->next()) {
$ret[$r['VERSION_ID']][] = $r['SITE_HOST_NAME'];
$ret[$r['VERSION_ID']][] = $r['VERSION_DATE_TIME'];
}
return $ret;
}
function listAllVersion()
{
global $_body;
$db = new objDBSQL();
$db->statement = "\n SELECT SITE_HOST_NAME,VERSION_DATE_TIME,VERSION_ID,SITE_ID\n FROM SITE\n LEFT JOIN VERSION ON VERSION_SITE_ID=SITE_ID\n\n ";
$db->execute();
$ret = array();
$_body .= "<table width='40%' align='center' border='1'>";
while ($r = $db->next()) {
$_body .= "<tr>";
$_body .= "<td width='20%'>" . $r['SITE_HOST_NAME'] . "</td>";
$_body .= "<td width='20%'>" . $r['VERSION_DATE_TIME'] . "</td>";
$_body .= "<td width='20%'>" . $r['SITE_ID'] . "</td>";
$_body .= "<td width='20%'>" . $r['VERSION_ID'] . "</td>";
$_body .= "</tr>";
}
$_body .= "</table>";
return $ret;
}
<?php
require_once "objDBSQL.pclass";
$db = new objDBSQL();
$db->clear_tables();
header('Location: /headline');