Tijden veranderen
Probleem met dropdownlist
Nu ik kan speeldag 1 t/m 34 laten zien maar ik wil ook alle wedstrijden laten zien. Hoe kan ik dat juist doen. Gelieve met een voorbeeld want ik ben een newbie.
--- code
<form name="form1" method="post" action="">
<div align="center">
<select name="select">
<option value="SP1">Speeldag 1</option>
<option value="SP2">Speeldag 2</option>
<option value="SP3">Speeldag 3</option>
<option value="SP4">Speeldag 4</option>
<option value="SP5">Speeldag 5</option>
<option value="SP6">Speeldag 6</option>
<option value="SP7">Speeldag 7</option>
<option value="SP8">Speeldag 8</option>
<option value="SP9">Speeldag 9</option>
<option value="SP10">Speeldag 10</option>
<option value="SP11">Speeldag 11</option>
<option value="SP12">Speeldag 12</option>
<option value="SP13">Speeldag 13</option>
<option value="SP14">Speeldag 14</option>
<option value="SP15">Speeldag 15</option>
<option value="SP16">Speeldag 16</option>
<option value="SP17">Speeldag 17</option>
<option value="SP18">Speeldag 18</option>
<option value="SP19">Speeldag 19</option>
<option value="SP20">Speeldag 20</option>
<option value="SP21">Speeldag 21</option>
<option value="SP22">Speeldag 22</option>
<option value="SP23">Speeldag 23</option>
<option value="SP24">Speeldag 24</option>
<option value="SP25">Speeldag 25</option>
<option value="SP26">Speeldag 26</option>
<option value="SP27">Speeldag 27</option>
<option value="SP28">Speeldag 28</option>
<option value="SP29">Speeldag 29</option>
<option value="SP30">Speeldag 30</option>
<option value="SP31">Speeldag 31</option>
<option value="SP32">Speeldag 32</option>
<option value="SP33">Speeldag 33</option>
<option value="SP34">Speeldag 34</option>
</select>
<input type="submit" name="Submit" value="Ok">
</div>
</form>
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
<?php
include ("inc_connect.php");
if(!isset($_POST["select"])){$_POST["select"] ="SP1";}
$query=mysql_db_query("$dbnaam","select * from kalender2006_2007 where W like '" .$_POST["select"]. "' order by ID;",$db);
//if(!isset($_POST["select"])){$_POST["select"] ="";}
//$query=mysql_db_query("$dbnaam","select * from kalender2006_2007 where R like '" .$_POST["select"]. "' order by DATUM asc;",$db);
//echo "\$query = $query <br>";
$aantal_lijnen=mysql_num_rows($query);
//echo "<div align='center'>";
//echo $_POST["select"];
//echo "</div>";
print("<table border = 0 width=485 cellspacing='0' align='center' style='font-size=14;'><tr align='center' ><td width=40><font color='#000000'>Dag</td>");
print("<td width=65><font color='#000000'>Datum</td>");
print("<td width=60><font color='#000000'>Uur</td>");
print("<td width=90><font color='#000000'>Thuisploeg</td>");
print("<td width=10><font color='#000000'></td>");
print("<td width=90><font color='#000000'>Bezoekers</td>");
print("<td width=40><font color='#000000'>W</td>");
print("<td width=30 ><font color='#000000'></td>");
print("<td width=10><font color='#000000'></td>");
print("<td width=30><font color='#000000'></td>");
for($i=0;$i<$aantal_lijnen;$i++) {
$row=mysql_fetch_row($query);
echo "<tr align='center'><td>$row[1]</td><td>$row[0]</td><td>$row[2]</td><td align='left'>$row[4]</td><td>-</td><td align='right'>$row[5]</td><td>$row[6]</td><td>$row[7]</td><td>-</td><td>$row[8]</td></tr>";
}
print("</table>");
?>
include ("inc_connect.php");
if(!isset($_POST["select"])){$_POST["select"] ="SP1";}
$query=mysql_db_query("$dbnaam","select * from kalender2006_2007 where W like '" .$_POST["select"]. "' order by ID;",$db);
//if(!isset($_POST["select"])){$_POST["select"] ="";}
//$query=mysql_db_query("$dbnaam","select * from kalender2006_2007 where R like '" .$_POST["select"]. "' order by DATUM asc;",$db);
//echo "\$query = $query <br>";
$aantal_lijnen=mysql_num_rows($query);
//echo "<div align='center'>";
//echo $_POST["select"];
//echo "</div>";
print("<table border = 0 width=485 cellspacing='0' align='center' style='font-size=14;'><tr align='center' ><td width=40><font color='#000000'>Dag</td>");
print("<td width=65><font color='#000000'>Datum</td>");
print("<td width=60><font color='#000000'>Uur</td>");
print("<td width=90><font color='#000000'>Thuisploeg</td>");
print("<td width=10><font color='#000000'></td>");
print("<td width=90><font color='#000000'>Bezoekers</td>");
print("<td width=40><font color='#000000'>W</td>");
print("<td width=30 ><font color='#000000'></td>");
print("<td width=10><font color='#000000'></td>");
print("<td width=30><font color='#000000'></td>");
for($i=0;$i<$aantal_lijnen;$i++) {
$row=mysql_fetch_row($query);
echo "<tr align='center'><td>$row[1]</td><td>$row[0]</td><td>$row[2]</td><td align='left'>$row[4]</td><td>-</td><td align='right'>$row[5]</td><td>$row[6]</td><td>$row[7]</td><td>-</td><td>$row[8]</td></tr>";
}
print("</table>");
?>
----- Database
Het veld R = reeks, in dit geval is dat R2
Het veld W = de speeldag SP1 t/m SP34
CREATE TABLE `kalender2006_2007` (
`Datum` text NOT NULL,
`Dag` varchar(10) NOT NULL default '',
`Uur` varchar(5) NOT NULL default '',
`R` varchar(7) NOT NULL default '',
`Thuisploeg` varchar(25) NOT NULL default '',
`Bezoekers` varchar(25) NOT NULL default '',
`W` varchar(5) NOT NULL default '',
`Dthuis` char(2) NOT NULL default '',
`Dbezoek` char(2) NOT NULL default '',
`ID` int(4) NOT NULL default '0'
) TYPE=MyISAM;
INSERT INTO `kalender2006_2007` VALUES ('23/08/2006', 'Woe', '18:30', 'R2', 'Flipper', 'Tornado's', 'SP1', '', '', 1);
INSERT INTO `kalender2006_2007` VALUES ('23/08/2006', 'Woe', '18:30', 'R2', 'De beund', 'The Gunners', 'SP1', '', '', 2);
INSERT INTO `kalender2006_2007` VALUES ('24/08/2006', 'Woe', '20:00', 'R2', 'The Gunners', 'Flipper', 'SP2', '', '', 3);
INSERT INTO `kalender2006_2007` VALUES ('24/08/2006', 'Woe', '18:30', 'R2', 'Tornado's', 'De Beunt', 'SP2', '', '', 4);
INSERT INTO `kalender2006_2007` VALUES ('25/08/2006', 'Woe', '18:30', 'R2', 'De Beunt', 'Flipper', 'SP3', '', '', 5);
INSERT INTO `kalender2006_2007` VALUES ('25/08/2006', 'Woe', '20:00', 'R2', 'Tornado's', 'The Gunners', 'SP3', '', '', 6);
`Datum` text NOT NULL,
`Dag` varchar(10) NOT NULL default '',
`Uur` varchar(5) NOT NULL default '',
heeft niets met datums te maken. Dit gaat je nog heel veel problemen opleveren.
Een datum (met tijd) sla je op in een DATE (of DATETIME) in het formaat yyyy-mm-dd hh:mm:ss. Zie verder de MySQL-handleiding, hoofdstuk 11.