";
$res = mysql_query("SELECT DISTINCT personnr FROM members WHERE `hr-medlem`=1 AND datum >= '".date("Y")."'");
$headers_written = false;
echo "
\r\n";
while(list($personnr) = mysql_fetch_row($res)) {
$personnr = mysql_real_escape_string($personnr);
$res2 = mysql_query("SELECT personnr, namn, nick, adress, mobiltelefon, hemtelefon, datum FROM members WHERE `hr-medlem`=1 AND datum >= '".date("Y")."' AND personnr='$personnr' AND forumid IN (SELECT Lanare FROM biljett WHERE Datum >= '".date("Y")."') ORDER BY datum DESC LIMIT 1");
$row = mysql_fetch_assoc($res2);
if(!$row) {
continue;
}
mysql_free_result($res2);
if(!$headers_written) {
echo "
\r\n";
foreach(array_keys($row) as $header) {
echo "
$header
";
}
echo "
\r\n";
$headers_written = true;
}
echo "
\r\n";
foreach(array_values($row) as $value) {
echo "
".($value ? $value : ' ')."
";
}
echo "
\r\n";
}
mysql_free_result($res);
echo "
\r\n";
} else {
require_once("toppen.php");
echo "Logga in som crew.";
require_once("botten.php");
}
?>