Kalender med kommentar til datoer
hey er ved at bygge en kalender hvor man skulle kunne tilføj kommentar til forskellige datoer, det virker også fint nok, men så aligevel ikke :Pnår jeg skriver 2 kommentar til samme måned, gentages helle måneden 2 gang, hvor den kun skulle give den dato, som nu var kommenteret et link?
håber i forstår, i kan se kalenderen her : http://www.flol.frac.dk/test/kalender.php
... koden ... :
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Kalender</title>
</head>
<body>
Vælge Måned:
<form action="kalender.php" method="post">
<select name="maned">
<option value="Januar">Januar</option>
<option value="Februar">Februar</option>
<option value="Marts">Marts</option>
<option value="April">April</option>
<option value="Maj">Maj</option>
<option value="Juni">Juni</option>
<option value="Juli">Juli</option>
<option value="August">August</option>
<option value="September">September</option>
<option value="Oktober">Oktober</option>
<option value="Norvember">Norvember</option>
<option value="December">December</option>
</select>
<select name="aar">
<option value="2007">2007</option>
<option value="2008">2008</option>
<option value="2009">2009</option>
<option value="2010">2010</option>
<option value="2011">2011</option>
<option value="2012">2012</option>
<option value="2013">2013</option>
<option value="2014">2014</option>
<option value="2015">2015</option>
<option value="2016">2016</option>
<option value="2017">2017</option>
<option value="2018">2018</option>
<option value="2019">2019</option>
<option value="2020">2020</option>
</select>
<input type="submit" value="Vælge" name="submit" />
</form>
<?
include("connect.php");
if(isset($_POST['submit'])) {
$maned = $_POST['maned'];
$query = mysql_query("SELECT * FROM kalender WHERE maned = '$maned'") or die(mysql_error());
$row = mysql_fetch_assoc($query);
$quer = mysql_query("SELECT * FROM kalender_opslag WHERE maned = '$maned'") or die(mysql_error());
}else{
$query = mysql_query("SELECT * FROM kalender WHERE maned = ''") or die(mysql_error());
$row = mysql_fetch_assoc($query);
$quer = mysql_query("SELECT * FROM kalender_opslag WHERE maned = ''") or die(mysql_error());
}
while($ro = mysql_fetch_assoc($quer)) {
$id = $ro['id'];
?>
<table width="409" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td>Mandag</td>
<td>Tirsdag</td>
<td>Onsdag</td>
<td>Torsdag</td>
<td>Fredag</td>
<td>Lørdag</td>
<td>Søndsg</td>
</tr>
<tr>
<td><? if(!$ro['dag1'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag1']; ?>"><? echo $row['dag1']; ?></a><? }else{ echo $row['dag1']; } ?></td>
<td><? if(!$ro['dag2'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag2']; ?>"><? echo $row['dag2']; ?></a><? }else{ echo $row['dag2']; } ?></td>
<td><? if(!$ro['dag3'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag3']; ?>"><? echo $row['dag3']; ?></a><? }else{ echo $row['dag3']; } ?></td>
<td><? if(!$ro['dag4'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag4']; ?>"><? echo $row['dag4']; ?></a><? }else{ echo $row['dag4']; } ?></td>
<td><? if(!$ro['dag5'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag5']; ?>"><? echo $row['dag5']; ?></a><? }else{ echo $row['dag5']; } ?></td>
<td><? if(!$ro['dag6'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag6']; ?>"><? echo $row['dag6']; ?></a><? }else{ echo $row['dag6']; } ?></td>
<td><? if(!$ro['dag7'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag7']; ?>"><? echo $row['dag7']; ?></a><? }else{ echo $row['dag7']; } ?></td>
</tr>
<tr>
<td><? if(!$ro['dag8'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag8']; ?>"><? echo $row['dag8']; ?></a><? }else{ echo $row['dag8']; } ?></td>
<td><? if(!$ro['dag9'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag9']; ?>"><? echo $row['dag9']; ?></a><? }else{ echo $row['dag9']; } ?></td>
<td><? if(!$ro['dag10'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag10']; ?>"><? echo $row['dag10']; ?></a><? }else{ echo $row['dag10']; } ?></td>
<td><? if(!$ro['dag11'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag11']; ?>"><? echo $row['dag11']; ?></a><? }else{ echo $row['dag11']; } ?></td>
<td><? if(!$ro['dag12'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag12']; ?>"><? echo $row['dag12']; ?></a><? }else{ echo $row['dag12']; } ?></td>
<td><? if(!$ro['dag13'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag13']; ?>"><? echo $row['dag13']; ?></a><? }else{ echo $row['dag13']; } ?></td>
<td><? if(!$ro['dag14'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag14']; ?>"><? echo $row['dag14']; ?></a><? }else{ echo $row['dag14']; } ?></td>
</tr>
<tr>
<td><? if(!$ro['dag15'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag15']; ?>"><? echo $row['dag15']; ?></a><? }else{ echo $row['dag15']; } ?></td>
<td><? if(!$ro['dag16'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag16']; ?>"><? echo $row['dag16']; ?></a><? }else{ echo $row['dag16']; } ?></td>
<td><? if(!$ro['dag17'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag17']; ?>"><? echo $row['dag17']; ?></a><? }else{ echo $row['dag17']; } ?></td>
<td><? if(!$ro['dag18'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag18']; ?>"><? echo $row['dag18']; ?></a><? }else{ echo $row['dag18']; } ?></td>
<td><? if(!$ro['dag19'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag19']; ?>"><? echo $row['dag19']; ?></a><? }else{ echo $row['dag19']; } ?></td>
<td><? if(!$ro['dag20'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag20']; ?>"><? echo $row['dag20']; ?></a><? }else{ echo $row['dag20']; } ?></td>
<td><? if(!$ro['dag21'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag21']; ?>"><? echo $row['dag21']; ?></a><? }else{ echo $row['dag21']; } ?></td>
</tr>
<tr>
<td><? if(!$ro['dag22'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag22']; ?>"><? echo $row['dag22']; ?></a><? }else{ echo $row['dag22']; } ?></td>
<td><? if(!$ro['dag23'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag23']; ?>"><? echo $row['dag23']; ?></a><? }else{ echo $row['dag23']; } ?></td>
<td><? if(!$ro['dag24'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag24']; ?>"><? echo $row['dag24']; ?></a><? }else{ echo $row['dag24']; } ?></td>
<td><? if(!$ro['dag25'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag25']; ?>"><? echo $row['dag25']; ?></a><? }else{ echo $row['dag25']; } ?></td>
<td><? if(!$ro['dag26'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag26']; ?>"><? echo $row['dag26']; ?></a><? }else{ echo $row['dag26']; } ?></td>
<td><? if(!$ro['dag27'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag27']; ?>"><? echo $row['dag27']; ?></a><? }else{ echo $row['dag27']; } ?></td>
<td><? if(!$ro['dag28'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag28']; ?>"><? echo $row['dag28']; ?></a><? }else{ echo $row['dag28']; } ?></td>
</tr>
<tr>
<td><? if(!$ro['dag29'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag29']; ?>"><? echo $row['dag29']; ?></a><? }else{ echo $row['dag29']; } ?></td>
<td><? if(!$ro['dag30'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag30']; ?>"><? echo $row['dag30']; ?></a><? }else{ echo $row['dag30']; } ?></td>
<td><? if(!$ro['dag31'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag31']; ?>"><? echo $row['dag31']; ?></a><? }else{ echo $row['dag31']; } ?></td>
<td><? if(!$ro['dag32'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag32']; ?>"><? echo $row['dag32']; ?></a><? }else{ echo $row['dag32']; } ?></td>
<td><? if(!$ro['dag33'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag33']; ?>"><? echo $row['dag33']; ?></a><? }else{ echo $row['dag33']; } ?></td>
<td><? if(!$ro['dag34'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag34']; ?>"><? echo $row['dag34']; ?></a><? }else{ echo $row['dag34']; } ?></td>
<td><? if(!$ro['dag35'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag35']; ?>"><? echo $row['dag35']; ?></a><? }else{ echo $row['dag35']; } ?></td>
</tr>
<tr>
<td><? if(!$ro['dag36'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag36']; ?>"><? echo $row['dag36']; ?></a><? }else{ echo $row['dag36']; } ?></td>
<td><? if(!$ro['dag37'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag37']; ?>"><? echo $row['dag37']; ?></a><? }else{ echo $row['dag37']; } ?></td>
<td><? if(!$ro['dag38'] == "" ){ ?><a href="?info=<? echo "$id"; ?>&dag=<? echo $row['dag38']; ?>"><? echo $row['dag38']; ?></a><? }else{ echo $row['dag38']; } ?></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</table>
</body>
</html>
<?
}
if(!$_GET['info'] == "") {
$string = $_GET['info'];
$dag = $_GET['dag'];
$conn = mysql_query("SELECT * FROM kalender_opslag WHERE id = '$string'") or die(mysql_error());
$hent = mysql_fetch_assoc($conn);
$maned = $hent['maned'];
$aar = $hent['aar'];
?>
<table cellpadding="0" cellspacing="0" border="0" align="center">
<tr>
<td align="center" height="25" width="400"><? echo $hent['titel']; ?></td>
</tr>
<tr>
<td align="center" height="100" width="400"><? echo $hent['dag25']; ?></td>
</tr>
<tr>
<td height="100" width="400"><? echo "d.$dag" . " " . "$maned - " . "$aar"; ?></td>
</tr>
</table>
<? } ?>
