Slettet bruger
22. april 2012 - 18:07
Der er
21 kommentarer og
1 løsning
fejl i loop
Hej.
Jeg har fået hjælp i en anden tråd ->
http://www.eksperten.dk/spm/961192#reply_7933084MEN kunne ikke helt få det til at fungere alligevel og får intet svar fra brugeren der hjalp mig, så håber der er nogle her der kan hjælpe mig :-)
I nedenstående er koden jeg bruger på min test side, og linket til den oprindelige side, som viser hvordan det skal se ud.
Det er for at optimere koden jeg skal bruge dette. Se evt. tidliger tråd som jeg har linket til i toppen :-)
//Test side
<?php
include ('databasen.php');
$months_danish = array(
1 => "Januar",
2 => "Februar",
3 => "Marts",
4 => "April",
5 => "Maj",
6 => "Juni",
7 => "Juli",
8 => "August",
9 => "September",
10 => "Oktober",
11 => "November",
12 =>"December"
);
$html = array();
foreach( $months_danish as $key => $month) {
$html[] = '<a id="myHeader1" class="month" href="java script:showonlyone(\'newboxes'.$key.'\');">'.strtoupper($month).'</a>';
$html[] = '<div name="newboxes" id="newboxes'.$key.'" class="event_month">';
$sql = "SELECT * FROM events WHERE maanede='".strtolower($month)."' AND godkendt='1' ORDER BY date ASC";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
echo '<table id="event_table">';
echo '<tr><td><span class="event_dato">'.date('j. ',$row[date]).$months_danish[date('n',$row[date])].date(' Y',$row[date]).'</span></td></tr>';
echo '<tr><td><a class="event_title" href="eventen.php?id='.$row[id].'">'.substr($row["title"], 0, 35).'</a></td></tr>
</table>';
}
$html[] = '</div>';
}
echo implode("\n", $html); //Udskriver til sidst html-arrayet
?>
Her er linket til test side
http://www.afterlife.dk/ (...)
det ser lidt forkert ud, da det jo gerne skulle blive til det her
http://www.afterlife.dk/ (...)
Hvad gør jeg forkert? Har prøvet diverse ting, håber du kan se fejlen.
Slettet bruger
22. april 2012 - 21:27
#9
Dette er test.php
//content
<div id="content">
<?php
include ('db.php');
$months_danish = array(
1 => "Januar",
2 => "Februar",
3 => "Marts",
4 => "April",
5 => "Maj",
6 => "Juni",
7 => "Juli",
8 => "August",
9 => "September",
10 => "Oktober",
11 => "November",
12 =>"December"
);
$html = array();
foreach( $months_danish as $key => $month) {
$html[] = '<a id="myHeader1" class="month" href="java script:showonlyone(\'newboxes'.$key.'\');">'.strtoupper($month).'</a>';
$html[] = '<div name="newboxes" id="newboxes'.$key.'" class="event_month">';
$sql = "SELECT * FROM events WHERE maanede='".strtolower($month)."' AND godkendt='1' ORDER BY date ASC";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
echo '<table id="event_table">';
echo '<tr><td><span class="event_dato">'.date('j. ',$row[date]).$months_danish[date('n',$row[date])].date(' Y',$row[date]).'</span></td></tr>';
echo '<tr><td><a class="event_title" href="eventen.php?id='.$row[id].'">'.substr($row["title"], 0, 35).'</a></td></tr>
</table>';
}
$html[] = '</div>';
}
echo implode("\n", $html); //Udskriver til sidst html-arrayet
?>
</div>
//slut
Detter er den aktuelle events.php
//content
<div id="content">
<a id="myHeader1" class="month" href="java script:showonlyone('newboxes1');">januar</a>
<div name="newboxes" id="newboxes1" class="event_month">
<?php
$months_danish = array("Januar", "Februar", "Marts", "April", "Maj", "Juni", "Juli", "August", "September", "Oktober", "November", "December");
include ('db.php');
$sql = "SELECT * FROM events WHERE maanede='januar' AND godkendt='1' ORDER BY date ASC";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
echo '<table id="event_table">';
echo '<tr><td><span class="event_dato">'.date('j. ',$row[date]).$months_danish[date('n',$row[date])-1].date(' Y',$row[date]).'</span></td></tr>';
echo '<tr><td><a class="event_title" href="eventen.php?id='.$row[id].'">'.substr($row["title"], 0, 35).'</a></td></tr>
</table>';
}
?>
</div>
<a id="myHeader2" class="month" href="java script:showonlyone('newboxes2');">februar</a>
<div name="newboxes" id="newboxes2" class="event_month">
<?php
$sql = "SELECT * FROM events WHERE maanede='februar' AND godkendt='1' ORDER BY date ASC";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
echo '<table id="event_table">';
echo '<tr><td><span class="event_dato">'.date('j. ',$row[date]).$months_danish[date('n',$row[date])-1].date(' Y',$row[date]).'</span></td></tr>';
echo '<tr><td><a class="event_title" href="eventen.php?id='.$row[id].'">'.substr($row["title"], 0, 35).'</a></td></tr>
</table>';
}
?>
</div>
<a id="myHeader3" class="month" href="java script:showonlyone('newboxes3');">marts</a>
<div name="newboxes" id="newboxes3" class="event_month">
<?php
$sql = "SELECT * FROM events WHERE maanede='marts' AND godkendt='1' ORDER BY date ASC";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
echo '<table id="event_table">';
echo '<tr><td><span class="event_dato">'.date('j. ',$row[date]).$months_danish[date('n',$row[date])-1].date(' Y',$row[date]).'</span></td></tr>';
echo '<tr><td><a class="event_title" href="eventen.php?id='.$row[id].'">'.substr($row["title"], 0, 35).'</a></td></tr>
</table>';
}
?>
</div>
<a id="myHeader4" class="month" href="java script:showonlyone('newboxes4');">april</a>
<div name="newboxes" id="newboxes4" class="event_month">
<?php
$sql = "SELECT * FROM events WHERE maanede='april' AND godkendt='1' ORDER BY date ASC";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
echo '<div id="event_table">';
echo '<div class="event_maan">'.$months_danish[date('n',$row[date])-1].'</div>';
echo '<div class="event_date">'.date('j',$row[date]).'</div>';
echo '<span class="event_year">'.date('Y',$row[date]).'</span>';
echo '<div class="event_title"><a href="eventen.php?id='.$row[id].'">'.$row["title"].'</a></div></div>';
}
?>
</div>
<a id="myHeader5" class="month" href="java script:showonlyone('newboxes5');">maj</a>
<div name="newboxes" id="newboxes5" class="event_month">
<?php
$sql = "SELECT * FROM events WHERE maanede='maj' AND godkendt='1' ORDER BY date ASC";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
echo '<table id="event_table">';
echo '<tr><td><span class="event_dato">'.date('j. ',$row[date]).$months_danish[date('n',$row[date])-1].date(' Y',$row[date]).'</span></td></tr>';
echo '<tr><td><a class="event_title" href="eventen.php?id='.$row[id].'">'.substr($row["title"], 0, 35).'</a></td></tr>
</table>';
}
?>
</div>
<a id="myHeader6" class="month" href="java script:showonlyone('newboxes6');">juni</a>
<div name="newboxes" id="newboxes6" class="event_month">
<?php
$sql = "SELECT * FROM events WHERE maanede='juni' AND godkendt='1' ORDER BY date ASC";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
echo '<table id="event_table">';
echo '<tr><td><span class="event_dato">'.date('j. ',$row[date]).$months_danish[date('n',$row[date])-1].date(' Y',$row[date]).'</span></td></tr>';
echo '<tr><td><a class="event_title" href="eventen.php?id='.$row[id].'">'.substr($row["title"], 0, 35).'</a></td></tr>
</table>';
}
?>
</div>
<a id="myHeader7" class="month" href="java script:showonlyone('newboxes7');">juli</a>
<div name="newboxes" id="newboxes7" class="event_month">
<?php
$sql = "SELECT * FROM events WHERE maanede='juli' AND godkendt='1' ORDER BY date ASC";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
echo '<table id="event_table">';
echo '<tr><td><span class="event_dato">'.date('j. ',$row[date]).$months_danish[date('n',$row[date])-1].date(' Y',$row[date]).'</span></td></tr>';
echo '<tr><td><a class="event_title" href="eventen.php?id='.$row[id].'">'.substr($row["title"], 0, 35).'</a></td></tr>
</table>';
}
?>
</div>
<a id="myHeader8" class="month" href="java script:showonlyone('newboxes8');">august</a>
<div name="newboxes" id="newboxes8" class="event_month">
<?php
$sql = "SELECT * FROM events WHERE maanede='august' AND godkendt='1' ORDER BY date ASC";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
echo '<table id="event_table">';
echo '<tr><td><span class="event_dato">'.date('j. ',$row[date]).$months_danish[date('n',$row[date])-1].date(' Y',$row[date]).'</span></td></tr>';
echo '<tr><td><a class="event_title" href="eventen.php?id='.$row[id].'">'.substr($row["title"], 0, 35).'</a></td></tr>
</table>';
}
?>
</div>
<a id="myHeader9" class="month" href="java script:showonlyone('newboxes9');">sep</a>
<div name="newboxes" id="newboxes9" class="event_month">
<?php
$sql = "SELECT * FROM events WHERE maanede='september' AND godkendt='1' ORDER BY date ASC";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
echo '<table id="event_table">';
echo '<tr><td><span class="event_dato">'.date('j. ',$row[date]).$months_danish[date('n',$row[date])-1].date(' Y',$row[date]).'</span></td></tr>';
echo '<tr><td><a class="event_title" href="eventen.php?id='.$row[id].'">'.substr($row["title"], 0, 35).'</a></td></tr>
</table>';
}
?>
</div>
<a id="myHeader10" class="month" href="java script:showonlyone('newboxes10');">okt</a>
<div name="newboxes" id="newboxes10" class="event_month">
<?php
$sql = "SELECT * FROM events WHERE maanede='oktober' AND godkendt='1' ORDER BY date ASC";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
echo '<table id="event_table">';
echo '<tr><td><span class="event_dato">'.date('j. ',$row[date]).$months_danish[date('n',$row[date])-1].date(' Y',$row[date]).'</span></td></tr>';
echo '<tr><td><a class="event_title" href="eventen.php?id='.$row[id].'">'.substr($row["title"], 0, 35).'</a></td></tr>
</table>';
}
?>
</div>
<a id="myHeader11" class="month" href="java script:showonlyone('newboxes11');">nov</a>
<div name="newboxes" id="newboxes11" class="event_month">
<?php
$sql = "SELECT * FROM events WHERE maanede='november' AND godkendt='1' ORDER BY date ASC";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
echo '<table id="event_table">';
echo '<tr><td><span class="event_dato">'.date('j. ',$row[date]).$months_danish[date('n',$row[date])-1].date(' Y',$row[date]).'</span></td></tr>';
echo '<tr><td><a class="event_title" href="eventen.php?id='.$row[id].'">'.substr($row["title"], 0, 35).'</a></td></tr>
</table>';
}
?>
</div>
<a id="myHeader12" class="month" href="java script:showonlyone('newboxes12');">dec</a>
<div name="newboxes" id="newboxes12" class="event_month">
<?php
$sql = "SELECT * FROM events WHERE maanede='december' AND godkendt='1' ORDER BY date ASC";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
echo '<table id="event_table">';
echo '<tr><td><span class="event_dato">'.date('j. ',$row[date]).$months_danish[date('n',$row[date])-1].date(' Y',$row[date]).'</span></td></tr>';
echo '<tr><td><a class="event_title" href="eventen.php?id='.$row[id].'">'.substr($row["title"], 0, 35).'</a></td></tr>
</table>';
}
?>
</div>
</div>//slut