2 # Some useful definitions for Infodrom Linx
5 <define-tag linxtop whitespace=delete>
6 <div style="padding-top: 5px;"></div>
7 <a href="<root_prefix>linx/"><img src="<root_prefix>gifs/linx.gif" border=0 width=228 height=55 alt="Infodrom Linx"></a><p>
10 <define-tag linxbot whitespace=delete>
11 <div align="right"><img src="<root_prefix>gifs/powered_by_linux.gif" alt="Powered by Linux"></div>
14 <define-tag linxcolh>00c8ff</define-tag>
15 <define-tag linxcold>e6e8fa</define-tag>
16 <define-tag linxcoln>ffffff</define-tag>
18 <define-tag recent>10</define-tag>
22 $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
23 or die("Unable to connect to SQL server");
25 $sth = pg_exec ($dbh, "%0");
28 if (pg_NumRows ($sth) > 0) {
29 echo '<div class="linx">'."\n";
31 for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
32 $row = pg_fetch_array ($sth, $nr);
34 if ($category != $row['category']) {
35 printf ('<div class="category"><strong><a href="lookup.php?category=%s">%s</a></strong></div>'."\n",
36 urlencode($row['category']), $row['category']);
37 $category = $row['category'];
40 printf ('<div class="link%d"><a href="%s">%s</a></div>'."\n",
41 $linx, $row['url'], $row['subject']);