$sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
if (pg_NumRows ($sth) > 0) {
- echo ("<table width=\"100%\" border=\"0\" cellspacing=\"3\" bgcolor=\"#<cold>\" summary=\"\">");
- echo ("<tr><th width=\"10%\"><font face=\"Helvetica,Arial\">Paket</font></th>");
+ echo ("<table width=\"100%\" class=\"smallfont border\" cellspacing=\"1\" summary=\"\">");
+ echo ("<tr class=\"head\"><th width=\"10%\"><font face=\"Helvetica,Arial\">Paket</font></th>");
echo ("<th width=\"10%\"><font face=\"Helvetica,Arial\">Version</font></th>");
echo ("<th width=\"10%\"><font face=\"Helvetica,Arial\">Datum</font></th>");
echo ("<th width=\"70%\"><font face=\"Helvetica,Arial\">Subject</font></th></tr>");
}
+ $color = 0;
for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
$row = pg_fetch_array ($sth, $nr);
$date = explode (" ", $row['submitted']);
$date = explode ("-", $date[0]);
$date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]);
- printf ("<tr><td align=\"left\" width=\"10%%\"><font face=\"Helvetica,Arial\">%s</font></th>", $row['package']);
+ printf ("<tr class=\"t%d\"><td align=\"left\" width=\"10%%\"><font face=\"Helvetica,Arial\">%s</font></th>", $color, $row['package']);
printf ("<td align=\"left\" width=\"10%%\"><font face=\"Helvetica,Arial\">%s</font></th>", $row['version']);
printf ("<td align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%s</font></th>", $date);
printf ("<td align=\"left\" width=\"70%%\"><font face=\"Helvetica,Arial\"><a href=\"edit.php?id=%d\">%s</a></font></th></tr>",
$row['oid'], $row['subject']);
+ $color = !$color;
}
if (pg_NumRows ($sth) > 0) {
echo ("</table>");