<?phprequire_once("head.php");if($Crew) {echo "Bekräftade medlemmar ".date("Y").".<br /><br />";$res = mysql_query("SELECT DISTINCT personnr FROM members WHERE `hr-medlem`=1 AND datum >= '".date("Y")."'");$headers_written = false;echo "<table cellspacing=\"0\" border=\"1\">\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 "<tr>\r\n"; foreach(array_keys($row) as $header) { echo "<th>$header</th>"; } echo "</tr>\r\n"; $headers_written = true; } echo "<tr>\r\n"; foreach(array_values($row) as $value) { echo "<td>".($value ? $value : '<br>')."</td>"; } echo "</tr>\r\n";}mysql_free_result($res);echo "</table>\r\n";} else { require_once("toppen.php"); echo "Logga in som crew."; require_once("botten.php");}?>