Help with querystring that works with sql statement
Moderator: General Moderators
Help with querystring that works with sql statement
Hi
I have so far inserted this:
WHERE Weekday.WeekdayID='$wdid' && Classroom.ClassroomID='$crid'
And when this is the URL it works like a charm:
*.php?wdid=4&crid=1
But this only selects one of each and discards the rest, what should I do to show more than one or all classrooms or weekdays.
And what if somebody writes just the file in. *.php
Do you have a simpel solution to this?
I have so far inserted this:
WHERE Weekday.WeekdayID='$wdid' && Classroom.ClassroomID='$crid'
And when this is the URL it works like a charm:
*.php?wdid=4&crid=1
But this only selects one of each and discards the rest, what should I do to show more than one or all classrooms or weekdays.
And what if somebody writes just the file in. *.php
Do you have a simpel solution to this?
you're limiting the number of rows to return in your where clause.
if you want to include more in your results, don't narrow it down to the values in those columns.
if someone just hits yourpage.php w/o any url params, depending on how your server is set up, it will either just die, or you'll get a mysql error, or you wont' see anything at all.
you should check to see of those values are set before you run the query and default them if they're not.
if you want to include more in your results, don't narrow it down to the values in those columns.
if someone just hits yourpage.php w/o any url params, depending on how your server is set up, it will either just die, or you'll get a mysql error, or you wont' see anything at all.
you should check to see of those values are set before you run the query and default them if they're not.
one way to do it:
another way:
Id go with option number one, it'll be cleaner in the long run.
Code: Select all
$query = "select * from myTable".(isset($_GET['yourvar']) ? " where yourfield = '".$_GET['yourvar']."'" : "");Code: Select all
if(!isset($_GET['yourvar']))
$where = "%";
else
$where = $_GET['yourvar'];
$query = "select * from myTable where yourfield = '".$where."'";I have tryed the 5 line code and it works the same way as before. The 1 line code I have a hard time to implement cause my sql satement is quite advanced.
Here it is, mind the Danish.
Here it is, mind the Danish.
Code: Select all
$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 Ugedage.UgedagID='$udid' && Lokaler.LokaleID='$lkid' ORDER BY Lokaler.LokaleID, Ugedage.UgedagID, Timerfra.Timerfra ASC";You mean the page my users enter before they reach this databasepage?
I have not made that one yet cause I'd like to first learn how to part the sql before I can do just that.
My thought were to make links that were dynamically created via the sql, and no search option. The database is not that big.
I have not made that one yet cause I'd like to first learn how to part the sql before I can do just that.
My thought were to make links that were dynamically created via the sql, and no search option. The database is not that big.
This is all the code I use nothing more nothing less
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
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>";
?>*.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
Your kidding me is it this easy:
but i guess it is not so good regarding security?
Code: Select all
WHERE ((Lokaler.LokaleID='$lkid' && Sæsoner.SæsonID='$ssid') || (Ugedage.UgedagID='$udid' && Sæsoner.SæsonID='$ssid') || (Stilarter.StilartID='$said' && Sæsoner.SæsonID='$ssid') || (Niveauer.NiveauID='$nvid' && Sæsoner.SæsonID='$ssid') || (Undervisere.UnderviserID='$uvid' && Sæsoner.SæsonID='$ssid'))