<%
require("../../temp/ref.htm");
###################################################
# (Disney-) Lexikon (c) Thomas.Tausend@DLPfan.ORG #
###################################################
# timestamp_mysql2german - wandelt ein MySQL-Timestamp
# in ein traditionelles deutsches Datum um.
#
function mysqlts2de($t) {
return sprintf("%02d.%02d.%04d",
substr($t, 6, 2),
substr($t, 4, 2),
substr($t, 0, 4));
}
function mysql2de($datum) {
list($jahr, $monat, $tag) = explode("-", $datum);
return sprintf("%02d.%02d.%04d", $tag, $monat, $jahr);
}
require("../../scripts/dbdetails.php");
$dbcode = mysql_connect($host,$user,$pw) or die ("Kein Kontakt zur Datenbank");
mysql_select_db($db);
$thismonth=date("F",mktime(0,0,0,$month,1,date("Y")));
%>
<%
if(!$month) $month=date("m");
$query = "select *, date_format(date,\"%d.%m.%Y\") as datum, date_format(date, \"%d-%m\") as damo, date_format(date, \"%d\") as day, date_format(date, \"%Y\") as year from date LEFT JOIN keywords ON date.linkto = keywords.id WHERE date_format(date, \"%m\")=$month AND ok !='' ORDER BY damo";
# $query="SELECT * FROM keywords ORDER BY headline";
$result = mysql_query($query);
$anzahl=mysql_numrows($result);
$today = date("d-m");
%>