function show_db()
{
setlocale (LC_ALL, “nl_NL”);
// host, database and user information
include (“../../../../includes/readonly.inc”);
$Today = Date(‘d M Y H:i:s’);
echo (‘For changes, questions or comments please contact Ton Ensink.’);
echo (‘ Source: http://www.ton-ensink.com/mylinks.’ .”
“);
echo (‘This report is generated: ‘ . “” . $Today . “” . “.” .”
“);
$query = “SELECT * FROM LINKS
WHERE (Personal = 1 AND ShowOnWeb = 1)
ORDER BY Category, LINKORDER, PROGRAM”;
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$nrows = mysql_num_rows($result);
echo (‘Number of entries displayed: ‘ . “” . $nrows . “” . “.” .”
“);
print ”
“;
while ($i=mysql_fetch_array($result))
{
$Link = “$i[Description]“;
print ”
“;
}
print ”
Category | Link | Notes | Program |
$i[Category] | $Link | $i[Notes] | $i[Program] |
“;
}
?>
Ton’s Favorite Links
show_db();
?>
End of page