This is all the code I use nothing more nothing less
Code: Select all
<?
$username="???";
$password="???";
$database="???";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die("Unable to select database");
$query="SELECT Hold.*, Sæsoner.*, Timerfra.*, Minutterfra.*, Timertil.*, Minuttertil.*, Niveauer.*, Stilarter.*, Lokaler.*, Byer.*, Ugedage.*, Undervisere.*
FROM Undervisere INNER JOIN (Ugedage INNER JOIN (Timertil INNER JOIN (Timerfra INNER JOIN (Sæsoner INNER JOIN (Stilarter INNER JOIN (Niveauer RIGHT JOIN (Minuttertil INNER JOIN (Minutterfra INNER JOIN ((Byer INNER JOIN Lokaler ON Byer.ByID = Lokaler.ByID) INNER JOIN Hold ON Lokaler.LokaleID = Hold.LokaleID) ON Minutterfra.MinutterfraID = Hold.MinutterfraID) ON Minuttertil.MinuttertilID = Hold.MinuttertilID) ON Niveauer.NiveauID = Hold.NiveauID) ON Stilarter.StilartID = Hold.StilartID) ON Sæsoner.SæsonID = Hold.SæsonID) ON Timerfra.TimerfraID = Hold.TimerfraID) ON Timertil.TimertilID = Hold.TimertilID) ON Ugedage.UgedagID = Hold.UgedagID) ON Undervisere.UnderviserID = Hold.UnderviserID
WHERE Sæsoner.SæsonID='$ssid' && Ugedage.UgedagID='$udid' && Lokaler.LokaleID='$lkid' ORDER BY Lokaler.LokaleID, Ugedage.UgedagID, Timerfra.Timerfra ASC";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo "<b><center>Database Output</center></b><br><br>";
?>
<table width="100%" border="1" cellspacing="2" cellpadding="2" class="sortable" id="1">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Nr.</font></th>
<th><font face="Arial, Helvetica, sans-serif">Holdnr</font></th>
<th><font face="Arial, Helvetica, sans-serif">Stilart</font></th>
<th><font face="Arial, Helvetica, sans-serif">niveau</font></th>
<th><font face="Arial, Helvetica, sans-serif">Tid</font></th>
<th><font face="Arial, Helvetica, sans-serif">Lokale</font></th>
<th><font face="Arial, Helvetica, sans-serif">Ugedag</font></th>
<th><font face="Arial, Helvetica, sans-serif">Underviser</font></th>
</tr>
<?
$i=0;
while ($i < $num) {
$holdnr=mysql_result($result,$i,"holdnr");
$timerfra=mysql_result($result,$i,"timerfra");
$minutterfra=mysql_result($result,$i,"minutterfra");
$timertil=mysql_result($result,$i,"timertil");
$minuttertil=mysql_result($result,$i,"minuttertil");
$alderfra=mysql_result($result,$i,"alderfra");
$aldertil=mysql_result($result,$i,"aldertil");
$niveau=mysql_result($result,$i,"niveau");
$niveauid=mysql_result($result,$i,"niveauid");
$stilartnavn=mysql_result($result,$i,"stilartnavn");
$lokale=mysql_result($result,$i,"lokale");
$ugedag=mysql_result($result,$i,"ugedag");
$undervisernavn=mysql_result($result,$i,"undervisernavn");
?>
<tr>
<td><font face="Arial, Helvetica, sans-serif"><? echo $i+1; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo $holdnr; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo $stilartnavn; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? if ($niveauid=="0") {echo $alderfra." - ".$aldertil." år";} elseif ($alderfra=="0") {echo $niveau;} else {echo $alderfra." - ".$aldertil." år, ".$niveau;} ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo $timerfra.":".$minutterfra." - ".$timertil.":".$minuttertil; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo $lokale; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo $ugedag; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo $undervisernavn; ?></font></td>
</tr>
<?
$i++;
}
echo "</table>";
?>
and I then use this url:
*.php?ssid=1&udid=1&lkid=4_connect(localhost,$username,$password);
@mysql_select_db($database) or die("Unable to select database"e;);
$query="e;SELECT Hold.*, Sæsoner.*, Timerfra.*, Minutterfra.*, Timertil.*, Minuttertil.*, Niveauer.*, Stilarter.*, Lokaler.*, Byer.*, Ugedage.*, Undervisere.*
FROM Undervisere INNER JOIN (Ugedage INNER JOIN (Timertil INNER JOIN (Timerfra INNER JOIN (Sæsoner INNER JOIN (Stilarter INNER JOIN (Niveauer RIGHT JOIN (Minuttertil INNER JOIN (Minutterfra INNER JOIN ((Byer INNER JOIN Lokaler ON Byer.ByID = Lokaler.ByID) INNER JOIN Hold ON Lokaler.LokaleID = Hold.LokaleID) ON Minutterfra.MinutterfraID = Hold.MinutterfraID) ON Minuttertil.MinuttertilID = Hold.MinuttertilID) ON Niveauer.NiveauID = Hold.NiveauID) ON Stilarter.StilartID = Hold.StilartID) ON Sæsoner.SæsonID = Hold.SæsonID) ON Timerfra.TimerfraID = Hold.TimerfraID) ON Timertil.TimertilID = Hold.TimertilID) ON Ugedage.UgedagID = Hold.UgedagID) ON Undervisere.UnderviserID = Hold.UnderviserID
WHERE Sæsoner.SæsonID='$ssid' && Ugedage.UgedagID='$udid' && Lokaler.LokaleID='$lkid' ORDER BY Lokaler.LokaleID, Ugedage.UgedagID, Timerfra.Timerfra ASC";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo "<b><center>Database Output</center></b><br><br>"e;;
?>
<table width="e;100%"e; border="e;1"e; cellspacing="e;2"e; cellpadding="e;2"e; class="e;sortable"e; id="e;1"e;>
<tr>
<th><font face="e;Arial, Helvetica, sans-serif"e;>Nr.</font></th>
<th><font face="e;Arial, Helvetica, sans-serif"e;>Holdnr</font></th>
<th><font face="e;Arial, Helvetica, sans-serif"e;>Stilart</font></th>
<th><font face="e;Arial, Helvetica, sans-serif"e;>niveau</font></th>
<th><font face="e;Arial, Helvetica, sans-serif"e;>Tid</font></th>
<th><font face="e;Arial, Helvetica, sans-serif"e;>Lokale</font></th>
<th><font face="e;Arial, Helvetica, sans-serif"e;>Ugedag</font></th>
<th><font face="e;Arial, Helvetica, sans-serif"e;>Underviser</font></th>
</tr>
<?
$i=0;
while ($i < $num) {
$holdnr=mysql_result($result,$i,"e;holdnr"e;);
$timerfra=mysql_result($result,$i,"e;timerfra"e;);
$minutterfra=mysql_result($result,$i,"e;minutterfra"e;);
$timertil=mysql_result($result,$i,"e;timertil"e;);
$minuttertil=mysql_result($result,$i,"e;minuttertil"e;);
$alderfra=mysql_result($result,$i,"e;alderfra"e;);
$aldertil=mysql_result($result,$i,"e;aldertil"e;);
$niveau=mysql_result($result,$i,"e;niveau"e;);
$niveauid=mysql_result($result,$i,"e;niveauid"e;);
$stilartnavn=mysql_result($result,$i,"e;stilartnavn"e;);
$lokale=mysql_result($result,$i,"e;lokale"e;);
$ugedag=mysql_result($result,$i,"e;ugedag"e;);
$undervisernavn=mysql_result($result,$i,"e;undervisernavn"e;);
?>
<tr>
<td><font face="e;Arial, Helvetica, sans-serif"e;><? echo $i+1; ?></font></td>
<td><font face="e;Arial, Helvetica, sans-serif"e;><? echo $holdnr; ?></font></td>
<td><font face="e;Arial, Helvetica, sans-serif"e;><? echo $stilartnavn; ?></font></td>
<td><font face="e;Arial, Helvetica, sans-serif"e;><? if ($niveauid=="e;0"e;) {echo $alderfra."e; - "e;.$aldertil."e; år"e;;} elseif ($alderfra=="e;0"e;) {echo $niveau;} else {echo $alderfra."e; - "e;.$aldertil."e; år, "e;.$niveau;} ?></font></td>
<td><font face="e;Arial, Helvetica, sans-serif"e;><? echo $timerfra."e;:"e;.$minutterfra."e; - "e;.$tByer INNER JOIN Lokaler ON Byer.ByID = Lokaler.ByID) INNER JOIN Hold ON Lokaler.LokaleID = Hold.LokaleID) ON Minutterfra.MinutterfraID = Hold.MinutterfraID) ON Minuttertil.MinuttertilID = Hold.MinuttertilID) ON Niveauer.NiveauID = Hold.NiveauID) ON Stilarter.StilartID = Hold.StilartID) ON Sæsoner.SæsonID = Hold.SæsonID) ON Timerfra.TimerfraID = Hold.TimerfraID) ON Timertil.TimertilID = Hold.TimertilID) ON Ugedage.UgedagID = Hold.UgedagID) ON Undervisere.UnderviserID = Hold.UnderviserID
WHERE Sæsoner.SæsonID='$ssid' && Ugedage.UgedagID='$udid' && Lokaler.LokaleID='$lkid' ORDER BY Lokaler.LokaleID, Ugedage.UgedagID, Timerfra.Timerfra ASC";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo "<b><center>Database Output</center></b><br><br>";
?>
<table width="100%" border="1" cellspacing="2" cellpadding="2" class="sortable" id="1">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Nr.</font></th>
<th><font face="Arial, Helvetica, sans-serif">Holdnr</font></th>
<th><font face="Arial, Helvetica, sans-serif">Stilart</font></th>
<th><font face="Arial, Helvetica, sans-serif">niveau</font></th>
<th><font face="Arial, Helvetica, sans-serif">Tid</font></th>
<th><font face="e;Arial, Helvetica, sans-serif"e;>Lokale</font></th>
<th><font face="e;Arial, Helvetica, sans-serif"e;>Ugedag</font></th>
<th><font face="e;Arial, Helvetica, sans-serif"e;>Underviser</font></th>
</tr>
<?
$i=0;
while ($i < $num) {
$holdnr=mysql_result($result,$i,"e;holdnr"e;);
$timerfra=mysql_result($result,$i,"e;timerfra"e;);
$minutterfra=mysql_result($result,$i,"e;minutterfra"e;);
$timertil=mysql_result($result,$i,"e;timertil"e;);
$minuttertil=mysql_result($result,$i,"e;minuttertil"e;);
$alderfra=mysql_result($result,$i,"e;alderfra"e;);
$aldertil=mysql_result($result,$i,"e;aldertil&am<?
$username="???";
$password="???";
$database="???";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die("Unable to select database");
$query="SELECT Hold.*, Sæsoner.*, Timerfra.*, Minutterfra.*, Timertil.*, Minuttertil.*, Niveauer.*, Stilarter.*, Lokaler.*, Byer.*, Ugedage.*, Undervisere.*
FROM Undervisere INNER JOIN (Ugedage INNER JOIN (Timertil INNER JOIN (Timerfra INNER JOIN (Sæsoner INNER JOIN (Stilarter INNER JOIN (Niveauer RIGHT JOIN (Minuttertil INNER JOIN (Minutterfra INNER JOIN ((Byer INNER JOIN Lokaler ON Byer.ByID = Lokaler.ByID) INNER JOIN Hold ON Lokaler.LokaleID = Hold.LokaleID) ON Minutterfra.MinutterfraID = Hold.MinutterfraID) ON Minuttertil.MinuttertilID = Hold.MinuttertilID) ON Niveauer.NiveauID = Hold.NiveauID) ON Stilarter.StilartID = Hold.StilartID) ON Sæsoner.SæsonID = Hold.SæsonID) ON Timerfra.TimerfraID = Hold.TimerfraID) ON Timertil.TimertilID = Hold.TimertilID) ON Ugedage.UgedagID = Hold.UgedagID) ON Undervisere.UnderviserID = Hold.UnderviserID
WHERE Sæsoner.SæsonID='$ssid' && Ugedage.UgedagID='$udid' && Lokaler.LokaleID='$lkid' ORDER BY Lokaler.LokaleID, Ugedage.UgedagID, Timerfra.Timerfra ASC";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo "<b><center>Database Output</center></b><br><br>";
?>
<table width="100%" border="1" cellspacing="2" cellpadding="2" class="sortable" id="1">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Nr.</font></th>
<th><font face="Arial, Helvetica, sans-serif">Holdnr</font></th>
<th><font face="Arial, Helvetica, sans-serif">Stilart</font></th>
<th><font face="Arial, Helvetica, sans-serif">niveau</font></th>
<th><font face="Arial, Helvetica, sans-serif">Tid</font></th>
<th><font face="Arial, Helvetica, sans-serif">Lokale</font></th>
<th><font face="Arial, Helvetica, sans-serif">Ugedag</font></th>
<th><font face="Arial, Helvetica, sans-serif">Underviser</font></th>
</tr>
<?
$i=0;
while ($i < $num) {
$holdnr=mysql_result($result,$i,"holdnr");
$timerfra=mysql_result($result,$i,"timerfra");
$minutterfra=mysql_result($result,$i,"minutterfra");
$timertil=mysql_result($result,$i,"timertil");
$minuttertil=mysql_result($result,$i,"minuttertil");
$alderfra=mysql_result($result,$i,"alderfra");
$aldertil=mysql_result($result,$i,"aldertil");
$niveau=mysql_result($result,$i,"niveau");
$niveauid=mysql_result($result,$i,"niveauid");
$stilartnavn=mysql_result($result,$i,"stilartnavn");
$lokale=mysql_result($result,$i,"lokale");
$ugedag=mysql_result($result,$i,"ugedag");
$undervisernavn=mysql_result($result,$i,"undervisernavn");
?>
<tr>
<td><font face="Arial, Helvetica, sans-serif"><? echo $i+1; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo $holdnr; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo $stilartnavn; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? if ($niveauid=="0") {echo $alderfra." - ".$aldertil." år";} elseif ($alderfra=="0") {echo $niveau;} else {echo $alderfra." - ".$aldertil." år, ".$niveau;} ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo $timerfra.":".$minutterfra." - ".$timertil.":".$minuttertil; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo $lokale; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo $ugedag; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo $undervisernavn; ?></font></td>
</tr>
<?
$i++;
}
echo "</table>";
?>
and I then use this url:
*.php?ssid=1&udid=1&lkid=4