Linjeskift i rapporten? (PHP)
I min feltet rapport gider den ikke lave mellem (space) / enter osv til en ny linje...Den skriver blot det hele ud i et...
En der kan rette det til for mig :( :( ?
-----------------------------------
tilfoej.php
-----------------------------------
<html>
<head>
<meta http-equiv="Content-Language" content="da">
<title></title>
<link rel="stylesheet" type="text/css" href="gfx.css">
</head>
<body bgcolor="#333333">
<font color="#FFFFFF" face="Verdana" style="font-size: 9pt">»
<span style="font-weight: 700">Tilføj/slet clanwar</font></span></p>
<?
$db = mysql_connect("localhost", "root", "");
mysql_select_db("valuable", $db);
if($_POST['skriv']){
$rapport = $_POST['rapport'];
mysql_query("INSERT INTO clanwars (modstander, type, spillere, map1, map2, dato_dag, dato_måned, dato_år, score_jeres, score_modstander, rapport, lineup) VALUES ('$_POST[modstander]', '$_POST[type]', '$_POST[spillere]', '$_POST[map1]', '$_POST[map2]', '$_POST[dato_dag]', '$_POST[dato_måned]', '$_POST[dato_år]', '$_POST[score_jeres]', '$_POST[score_modstander]', '$rapport', '$_POST[lineup]')");
}
?>
<form method=post action="tilfoej.php">
<input type=hidden NAME=skriv VALUE=1>
<div align="left">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="429" height="154">
<tr>
<td width="429" height="33" valign="top">
<table cellSpacing="0" cellPadding="0" align="left" border="0" height="193" width="423">
<tr>
<td height="3" width="118" valign="middle">
<font size="1" face="Verdana" color="#FFFFFF">Modstander:</font></td>
<td height="3" width="305" valign="middle" colspan="2">
<input type="text" name="modstander" size="20">
</td>
</tr>
<tr>
<td height="1" width="118" valign="middle">
<font size="1" face="Verdana" color="#FFFFFF">Type:</font></td>
<td height="1" width="305" valign="middle" colspan="2">
<input type="text" name="type" size="20">
</td>
</tr>
<tr>
<td height="19" width="118" valign="middle">
<font size="1" face="Verdana" color="#FFFFFF">Map 1:</font></td>
<td height="19" width="305" valign="middle" colspan="2">
<input type="text" name="map1" size="20">
</td>
</tr>
<tr>
<td height="21" width="118" valign="middle">
<font size="1" face="Verdana" color="#FFFFFF">Map 2:</font></td>
<td height="21" width="305" valign="middle" colspan="2">
<input type="text" name="map2" size="20">
</td>
</tr>
<tr>
<td height="21" width="118" valign="middle">
<font size="1" face="Verdana" color="#FFFFFF">Dato:</font></td>
<td width="305" height="21" valign="middle" colspan="2">
<SELECT name=dato_dag class='input'>
<OPTION value="" selected></OPTION>
<OPTION label=01 value=01>01</OPTION>
<OPTION label=02 value=02>02</OPTION>
<OPTION label=03 value=03>03</OPTION>
<OPTION label=04 value=04>04</OPTION>
<OPTION label=05 value=05>05</OPTION>
<OPTION label=06 value=06>06</OPTION>
<OPTION label=07 value=07>07</OPTION>
<OPTION label=08 value=08>08</OPTION>
<OPTION label=09 value=09>09</OPTION>
<OPTION label=10 value=10>10</OPTION>
<OPTION label=11 value=11>11</OPTION>
<OPTION label=12 value=12>12</OPTION>
<OPTION label=13 value=13>13</OPTION>
<OPTION label=14 value=14>14</OPTION>
<OPTION label=15 value=15>15</OPTION>
<OPTION label=16 value=16>16</OPTION>
<OPTION label=17 value=17>17</OPTION>
<OPTION label=18 value=18>18</OPTION>
<OPTION label=19 value=19>19</OPTION>
<OPTION label=20 value=20>20</OPTION>
<OPTION label=21 value=21>21</OPTION>
<OPTION label=22 value=22>22</OPTION>
<OPTION label=23 value=23>23</OPTION>
<OPTION label=24 value=24>24</OPTION>
<OPTION label=25 value=25>25</OPTION>
<OPTION label=26 value=26>26</OPTION>
<OPTION label=27 value=27>27</OPTION>
<OPTION label=28 value=28>28</OPTION>
<OPTION label=29 value=29>29</OPTION>
<OPTION label=30 value=30>30</OPTION>
<OPTION label=31 value=31>31</OPTION>
</SELECT>
<SELECT name=dato_måned class='input'>
<OPTION value="" selected></OPTION>
<OPTION label=januar value=01>januar</OPTION>
<OPTION label=februar value=02>februar</OPTION>
<OPTION label=marts value=03>marts</OPTION>
<OPTION label=april value=04>april</OPTION>
<OPTION label=maj value=05>maj</OPTION>
<OPTION label=juni value=06>juni</OPTION>
<OPTION label=Juli value=07>juli</OPTION>
<OPTION label=august value=08>august</OPTION>
<OPTION label=september value=09>september</OPTION>
<OPTION label=oktober value=10>oktober</OPTION>
<OPTION label=november value=11>november</OPTION>
<OPTION label=december value=12>december</OPTION>
</SELECT>
<SELECT name=dato_år class='input'>
<OPTION value="" selected></OPTION>
<OPTION label=2004 value=2004>2004</OPTION>
<OPTION label=2005 value=2005>2005</OPTION>
<OPTION label=2006 value=2006>2006</OPTION>
<OPTION label=2007 value=2007>2007</OPTION>
<OPTION label=2008 value=2008>2008</OPTION>
</SELECT>
</td>
</tr>
<tr>
<td height="1" width="118" valign="middle">
<font size="1" face="Verdana" color="#FFFFFF">Lineup:</font></td>
<td height="1" width="305" valign="middle" colspan="2">
<input type="text" name="lineup" size="35">
</td>
</tr>
<tr>
<td height="22" width="118" valign="middle">
<font size="1" face="Verdana" color="#FFFFFF">Spillere:</font></td>
<td height="22" width="305" valign="middle" colspan="2">
<SELECT name=spillere class='input'>
<OPTION value="" selected></OPTION>
<OPTION label=1vs1 value=1vs1>1vs1</OPTION>
<OPTION label=2vs2 value=2vs2>2vs2</OPTION>
<OPTION label=3vs3 value=3vs3>3vs3</OPTION>
<OPTION label=4vs4 value=4vs4>4vs4</OPTION>
<OPTION label=5vs5 value=5vs5>5vs5</OPTION>
</SELECT>
</td>
</tr>
<tr>
<td height="18" width="118" valign="middle">
<font size="1" face="Verdana" color="#FFFFFF">Jeres score:</font></td>
<td height="18" width="5" valign="middle" colspan="2">
<SELECT name=score_jeres class='input'>
<OPTION value="" selected></OPTION>
<OPTION label=00 value=00>00</OPTION>
<OPTION label=01 value=01>01</OPTION>
<OPTION label=02 value=02>02</OPTION>
<OPTION label=03 value=03>03</OPTION>
<OPTION label=04 value=04>04</OPTION>
<OPTION label=05 value=05>05</OPTION>
<OPTION label=06 value=06>06</OPTION>
<OPTION label=07 value=07>07</OPTION>
<OPTION label=08 value=08>08</OPTION>
<OPTION label=09 value=09>09</OPTION>
<OPTION label=10 value=10>10</OPTION>
<OPTION label=11 value=11>11</OPTION>
<OPTION label=12 value=12>12</OPTION>
<OPTION label=13 value=13>13</OPTION>
<OPTION label=14 value=14>14</OPTION>
<OPTION label=15 value=15>15</OPTION>
<OPTION label=16 value=16>16</OPTION>
<OPTION label=17 value=17>17</OPTION>
<OPTION label=18 value=18>18</OPTION>
<OPTION label=19 value=19>19</OPTION>
<OPTION label=20 value=20>20</OPTION>
<OPTION label=21 value=21>21</OPTION>
<OPTION label=22 value=22>22</OPTION>
<OPTION label=23 value=23>23</OPTION>
<OPTION label=24 value=24>24</OPTION>
<OPTION label=25 value=25>25</OPTION>
<OPTION label=26 value=26>26</OPTION>
<OPTION label=27 value=27>27</OPTION>
<OPTION label=28 value=28>28</OPTION>
<OPTION label=29 value=29>29</OPTION>
<OPTION label=30 value=30>30</OPTION>
<OPTION label=31 value=31>31</OPTION>
<OPTION label=32 value=32>32</OPTION>
<OPTION label=33 value=33>33</OPTION>
<OPTION label=34 value=34>34</OPTION>
<OPTION label=35 value=35>35</OPTION>
<OPTION label=36 value=36>36</OPTION>
<OPTION label=37 value=37>37</OPTION>
<OPTION label=38 value=38>38</OPTION>
<OPTION label=39 value=39>39</OPTION>
<OPTION label=40 value=40>40</OPTION>
<OPTION label=41 value=41>41</OPTION>
<OPTION label=42 value=42>42</OPTION>
<OPTION label=43 value=43>43</OPTION>
<OPTION label=44 value=44>44</OPTION>
<OPTION label=45 value=45>45</OPTION>
<OPTION label=46 value=46>46</OPTION>
<OPTION label=47 value=47>47</OPTION>
<OPTION label=48 value=48>48</OPTION>
</SELECT></td>
</tr>
<tr>
<td height="23" width="118" valign="middle">
<font size="1" face="Verdana" color="#FFFFFF">Modstander score:</font> </td>
<td height="23" width="91" valign="middle">
<SELECT name=score_modstander class='input'>
<OPTION value="" selected></OPTION>
<OPTION label=00 value=00>00</OPTION>
<OPTION label=01 value=01>01</OPTION>
<OPTION label=02 value=02>02</OPTION>
<OPTION label=03 value=03>03</OPTION>
<OPTION label=04 value=04>04</OPTION>
<OPTION label=05 value=05>05</OPTION>
<OPTION label=06 value=06>06</OPTION>
<OPTION label=07 value=07>07</OPTION>
<OPTION label=08 value=08>08</OPTION>
<OPTION label=09 value=09>09</OPTION>
<OPTION label=10 value=10>10</OPTION>
<OPTION label=11 value=11>11</OPTION>
<OPTION label=12 value=12>12</OPTION>
<OPTION label=13 value=13>13</OPTION>
<OPTION label=14 value=14>14</OPTION>
<OPTION label=15 value=15>15</OPTION>
<OPTION label=16 value=16>16</OPTION>
<OPTION label=17 value=17>17</OPTION>
<OPTION label=18 value=18>18</OPTION>
<OPTION label=19 value=19>19</OPTION>
<OPTION label=20 value=20>20</OPTION>
<OPTION label=21 value=21>21</OPTION>
<OPTION label=22 value=22>22</OPTION>
<OPTION label=23 value=23>23</OPTION>
<OPTION label=24 value=24>24</OPTION>
<OPTION label=25 value=25>25</OPTION>
<OPTION label=26 value=26>26</OPTION>
<OPTION label=27 value=27>27</OPTION>
<OPTION label=28 value=28>28</OPTION>
<OPTION label=29 value=29>29</OPTION>
<OPTION label=30 value=30>30</OPTION>
<OPTION label=31 value=31>31</OPTION>
<OPTION label=32 value=32>32</OPTION>
<OPTION label=33 value=33>33</OPTION>
<OPTION label=34 value=34>34</OPTION>
<OPTION label=35 value=35>35</OPTION>
<OPTION label=36 value=36>36</OPTION>
<OPTION label=37 value=37>37</OPTION>
<OPTION label=38 value=38>38</OPTION>
<OPTION label=39 value=39>39</OPTION>
<OPTION label=40 value=40>40</OPTION>
<OPTION label=41 value=41>41</OPTION>
<OPTION label=42 value=42>42</OPTION>
<OPTION label=43 value=43>43</OPTION>
<OPTION label=44 value=44>44</OPTION>
<OPTION label=45 value=45>45</OPTION>
<OPTION label=46 value=46>46</OPTION>
<OPTION label=47 value=47>47</OPTION>
<OPTION label=48 value=48>48</OPTION>
</SELECT></td>
<td height="23" width="218" valign="middle">
<p align="right">
<font size="1" face="Verdana" color="#FFFFFF">Rapport: </font></td>
</tr>
<tr>
<td vAlign="top" height="54" width="86">
</td>
<td height="54" width="310" valign="top" colspan="2">
<font color="#FFFFFF" face="Verdana" size="1">
<textarea class="input" type="text" style="WIDTH: 300px; HEIGHT: 90px" name="rapport" rows="10" cols="40" wrap="on"></textarea>
</font></td>
</tr>
<tr>
<td height="20" width="118"></td>
<td height="20" width="305" valign="top" colspan="2">
<input type="submit" name="submit" value="tilføj" style="color: #000000; background-color: #FFFFFF; border:1px solid #9A9A9A;"></td>
</tr>
</table>
</td>
</tr>
</table>
</div>
</form>
<?
$resultat = mysql_query("select * from clanwars");
$nummer = mysql_num_rows($resultat);
if ($nummer <= 0) {
echo "<font face='Verdana' color='#ffffff' size='1'> - Der er ikke spillet nogle clanwars endnu</font></span></p>";
} else {
echo "<font face='Verdana' color='#ffffff' size='1'> - Der er spillet $nummer clanwars ialt</font></span></p>";
}
?>
</p>
<table border='0' bordercolor='#808080' style='border-collapse: collapse' height="36">
<tr bgcolor='#13161F'>
<td width='90' height='16'><font face='Verdana' color='#ffffff' size='1'><b>Modstander</b></td>
<td width='120' height='16'><font face='Verdana' color='#ffffff' size='1'><b>Type</b></td>
<td width='155' height='16'><font face='Verdana' color='#ffffff' size='1'><b>Map(s)</b></td>
<td width='85' height='16'><font face='Verdana' color='#ffffff' size='1'><b>Dato</b></td>
<td width='40' height='16'><font face='Verdana' color='#ffffff' size='1'><b>Score</b></td>
<td width='20' height='16'><font face='Verdana' color='#ffffff' size='1'> </font></td>
<td width='30' height='16'><font face='Verdana' color='#ffffff' size='1'> </font></td>
</tr>
<?
$foresp = mysql_query("SELECT modstander, type, spillere, map1, map2, dato_dag, dato_måned, dato_år, score_jeres, score_modstander, rapport, lineup, nr FROM clanwars ORDER BY nr DESC");
if(!$foresp){
//noget gik galt.
die("Fejl ved SQL udførsel: ".mysql_error());
}
while($data = mysql_fetch_row($foresp)){
echo "
<tr><td width='90' height='13'><font face='Verdana' color='#ffffff' size='1'>$data[0]</font></td>";
echo "<td width='120' height='13'><font face='Verdana' color='#ffffff' size='1'>$data[1]</font></td>";
echo "<td width='155' height='13'><font face='Verdana' color='#ffffff' size='1'>$data[3] / $data[4]</font></td>";
echo "<td width='85' height='13'><font face='Verdana' color='#ffffff' size='1'>$data[5]/$data[6]-$data[7]</font></td>";
if ($data[8] > $data[9]) {
$color = "#008000";
} elseif ($data[9] > $data[8]) {
$color = "#FF0000";
} else {
$color = "#000080";
}
echo "<td width='40' height='13'><font face='Verdana' color='$color' size='1'>$data[8]-$data[9]</font></td>";
echo "<td width='20' height='13'><a href='rapport_admin.php?nr=$data[12]'><img src='rapport.gif' border='0' width='10' height='12'></a></td>";
echo "<td width='30' height='13'><a href='slet_clanwars.php?nr=$data[12]' style='text-decoration: none'><font face='Verdana' color='#ff0000' size='1'><b>SLET</b></font></a></td></tr>";
}
?>
</font>
</table>
<br>
<font face="Verdana"><a href="index.php"><font color="#FFFFFF" size="1">Se clanwars</font></a></font>
</body>
</html>
