indhold fra db skal deles ind i grupper!

Det hele skal ofc være automatisk.

sådan ser min db_news ud

CREATE TABLE `db_news` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(40) NOT NULL,
  `img` varchar(40) NOT NULL,
  `content` text NOT NULL,
  `date` varchar(20) NOT NULL,
  `posted_by` varchar(20) NOT NULL,
  PRIMARY KEY  (`id`)
);

når jeg sætter date ind i date bliver det gjord sådan her.
$date = date('F d Y');

Archive siden som den ser ud nu

<h1>News Archive</h1>
<p>
Her kan du se alle de nyheder som vi har posted i løbet af ReTAKE's tid.
</p>
<?
    $SQL = "SELECT * FROM db_news ORDER BY `id` DESC";
    $loadin = mysql_query($SQL) or die("There is an Error in the database");
    while ($Get = mysql_fetch_object($loadin)){
?>
<div id='contentbox'><h2><?=nl2br($Get->title)?></h2><img src='news/images/news_<?=nl2br($Get->img)?>.jpg' />
<?=nl2br($Get->content)?>
<i class='date'>Posted: <?=nl2br($Get->date)?></i></div>
<? }?>

Her er den side jeg har lavet men prob er den ikke laver det hele automatisk.' Jeg har også tilføjet month og year til database.

Siden som den er nu.
<h1>News Archive</h1>
<p>
Her kan du se alle de nyheder som vi har posted i løbet af ReTAKE's tid.
</p>
<?
$SQL = "SELECT * FROM retake_news WHERE month = 'Januar' ORDER BY `id` DESC";
$loadin = mysql_query($SQL) or die("There is an Error in the database");
if(mysql_num_rows($loadin) != "0"){
?>
<h2>(<? echo(mysql_num_rows($loadin));?>) Januar <a href="?page=<? print($_GET['page']);?>&m=Jan">+</a></h2>
<?
    if($_GET['m'] == "Jan"){
    while ($Get = mysql_fetch_object($loadin)){
?>
<div id='contentbox'><h2><?=nl2br($Get->title)?></h2><img src='news/images/news_<?=nl2br($Get->img)?>.jpg' />
<?=nl2br($Get->content)?>
<i class='date'>Posted: <?=nl2br($Get->date)?></i></div>
<? }?><br />
<?
    }}
    $SQL = "SELECT * FROM retake_news WHERE month = 'Februar' ORDER BY `id` DESC";
    $loadin = mysql_query($SQL) or die("There is an Error in the database");
    if(mysql_num_rows($loadin) != "0"){
?>
<h2>(<? echo(mysql_num_rows($loadin));?>) Februar <a href="?page=<? print($_GET['page']);?>&m=Feb">+</a></h2>
<?
    if($_GET['m'] == "Feb"){
    while ($Get = mysql_fetch_object($loadin)){
?>
<div id='contentbox'><h2><?=nl2br($Get->title)?></h2><img src='news/images/news_<?=nl2br($Get->img)?>.jpg' />
<?=nl2br($Get->content)?>
<i class='date'>Posted: <?=nl2br($Get->date)?></i></div>
<? }?><br />
<?
    }}
    $SQL = "SELECT * FROM retake_news WHERE month = 'Marts' ORDER BY `id` DESC";
    $loadin = mysql_query($SQL) or die("There is an Error in the database");
    if(mysql_num_rows($loadin) != "0"){
?>
<h2>(<? echo(mysql_num_rows($loadin));?>) Marts <a href="?page=<? print($_GET['page']);?>&m=Mar">+</a></h2>
<?
    if($_GET['m'] == "Mar"){
    while ($Get = mysql_fetch_object($loadin)){
?>
<div id='contentbox'><h2><?=nl2br($Get->title)?></h2><img src='news/images/news_<?=nl2br($Get->img)?>.jpg' />
<?=nl2br($Get->content)?>
<i class='date'>Posted: <?=nl2br($Get->date)?></i></div>
<? }?><br />
<?
    }}
    $SQL = "SELECT * FROM retake_news WHERE month = 'April' ORDER BY `id` DESC";
    $loadin = mysql_query($SQL) or die("There is an Error in the database");
    if(mysql_num_rows($loadin) != "0"){
?>
<h2>(<? echo(mysql_num_rows($loadin));?>) April <a href="?page=<? print($_GET['page']);?>&m=Apr">+</a></h2>
<?
    if($_GET['m'] == "Apr"){
    while ($Get = mysql_fetch_object($loadin)){
?>
<div id='contentbox'><h2><?=nl2br($Get->title)?></h2><img src='news/images/news_<?=nl2br($Get->img)?>.jpg' />
<?=nl2br($Get->content)?>
<i class='date'>Posted: <?=nl2br($Get->date)?></i></div>
<? }?><br />
<?
    }}
    $SQL = "SELECT * FROM retake_news WHERE month = 'Maj' ORDER BY `id` DESC";
    $loadin = mysql_query($SQL) or die("There is an Error in the database");
    if(mysql_num_rows($loadin) != "0"){
?>
<h2>(<? echo(mysql_num_rows($loadin));?>) Maj <a href="?page=<? print($_GET['page']);?>&m=Maj">+</a></h2>
<?
    if($_GET['m'] == "Maj"){
    while ($Get = mysql_fetch_object($loadin)){
?>
<div id='contentbox'><h2><?=nl2br($Get->title)?></h2><img src='news/images/news_<?=nl2br($Get->img)?>.jpg' />
<?=nl2br($Get->content)?>
<i class='date'>Posted: <?=nl2br($Get->date)?></i></div>
<? }?><br />
<?
    }}
    $SQL = "SELECT * FROM retake_news WHERE month = 'Juni' ORDER BY `id` DESC";
    $loadin = mysql_query($SQL) or die("There is an Error in the database");
    if(mysql_num_rows($loadin) != "0"){
?>
<h2>(<? echo(mysql_num_rows($loadin));?>) Juni <a href="?page=<? print($_GET['page']);?>&m=Jun">+</a></h2>
<?
    if($_GET['m'] == "Jun"){
    while ($Get = mysql_fetch_object($loadin)){
?>
<div id='contentbox'><h2><?=nl2br($Get->title)?></h2><img src='news/images/news_<?=nl2br($Get->img)?>.jpg' />
<?=nl2br($Get->content)?>
<i class='date'>Posted: <?=nl2br($Get->date)?></i></div>
<? }?><br />
<?
    }}
    $SQL = "SELECT * FROM retake_news WHERE month = 'Juli' ORDER BY `id` DESC";
    $loadin = mysql_query($SQL) or die("There is an Error in the database");
    if(mysql_num_rows($loadin) != "0"){
?>
<h2>(<? echo(mysql_num_rows($loadin));?>) Juli <a href="?page=<? print($_GET['page']);?>&m=Jul">+</a></h2>
<?
    if($_GET['m'] == "Jul"){
    while ($Get = mysql_fetch_object($loadin)){
?>
<div id='contentbox'><h2><?=nl2br($Get->title)?></h2><img src='news/images/news_<?=nl2br($Get->img)?>.jpg' />
<?=nl2br($Get->content)?>
<i class='date'>Posted: <?=nl2br($Get->date)?></i></div>
<? }?><br />
<?
    }}
    $SQL = "SELECT * FROM retake_news WHERE month = 'August' ORDER BY `id` DESC";
    $loadin = mysql_query($SQL) or die("There is an Error in the database");
    if(mysql_num_rows($loadin) != "0"){
?>
<h2>(<? echo(mysql_num_rows($loadin));?>) August <a href="?page=<? print($_GET['page']);?>&m=Aug">+</a></h2>
<?
    if($_GET['m'] == "Aug"){
    while ($Get = mysql_fetch_object($loadin)){
?>
<div id='contentbox'><h2><?=nl2br($Get->title)?></h2><img src='news/images/news_<?=nl2br($Get->img)?>.jpg' />
<?=nl2br($Get->content)?>
<i class='date'>Posted: <?=nl2br($Get->date)?></i></div>
<? }?><br />
<?
    }}
    $SQL = "SELECT * FROM retake_news WHERE month = 'September' ORDER BY `id` DESC";
    $loadin = mysql_query($SQL) or die("There is an Error in the database");
    if(mysql_num_rows($loadin) != "0"){
?>
<h2>(<? echo(mysql_num_rows($loadin));?>) September <a href="?page=<? print($_GET['page']);?>&m=Sep">+</a></h2>
<?
    if($_GET['m'] == "Sep"){
    while ($Get = mysql_fetch_object($loadin)){
?>
<div id='contentbox'><h2><?=nl2br($Get->title)?></h2><img src='news/images/news_<?=nl2br($Get->img)?>.jpg' />
<?=nl2br($Get->content)?>
<i class='date'>Posted: <?=nl2br($Get->date)?></i></div>
<? }?><br />
<?
    }}
    $SQL = "SELECT * FROM retake_news WHERE month = 'Oktober' ORDER BY `id` DESC";
    $loadin = mysql_query($SQL) or die("There is an Error in the database");
    if(mysql_num_rows($loadin) != "0"){
?>
<h2>(<? echo(mysql_num_rows($loadin));?>) Oktober <a href="?page=<? print($_GET['page']);?>&m=Okt">+</a></h2>
<?
    if($_GET['m'] == "Okt"){
    while ($Get = mysql_fetch_object($loadin)){
?>
<div id='contentbox'><h2><?=nl2br($Get->title)?></h2><img src='news/images/news_<?=nl2br($Get->img)?>.jpg' />
<?=nl2br($Get->content)?>
<i class='date'>Posted: <?=nl2br($Get->date)?></i></div>
<? }?><br />
<?
    }}
    $SQL = "SELECT * FROM retake_news WHERE month = 'November' ORDER BY `id` DESC";
    $loadin = mysql_query($SQL) or die("There is an Error in the database");
    if(mysql_num_rows($loadin) != "0"){
?>
<h2>(<? echo(mysql_num_rows($loadin));?>) November <a href="?page=<? print($_GET['page']);?>&m=Nov">+</a></h2>
<?
    if($_GET['m'] == "Nov"){
    while ($Get = mysql_fetch_object($loadin)){
?>
<div id='contentbox'><h2><?=nl2br($Get->title)?></h2><img src='news/images/news_<?=nl2br($Get->img)?>.jpg' />
<?=nl2br($Get->content)?>
<i class='date'>Posted: <?=nl2br($Get->date)?></i></div>
<? }?><br />
<?
    }}
    $SQL = "SELECT * FROM retake_news WHERE month = 'December' ORDER BY `id` DESC";
    $loadin = mysql_query($SQL) or die("There is an Error in the database");
    if(mysql_num_rows($loadin) != "0"){
?>
<h2>(<? echo(mysql_num_rows($loadin));?>) December <a href="?page=<? print($_GET['page']);?>&m=Dec">+</a></h2>
<?
    if($_GET['m'] == "Dec"){
    while ($Get = mysql_fetch_object($loadin)){
?>
<div id='contentbox'><h2><?=nl2br($Get->title)?></h2><img src='news/images/news_<?=nl2br($Get->img)?>.jpg' />
<?=nl2br($Get->content)?>
<i class='date'>Posted: <?=nl2br($Get->date)?></i></div>
<? }}}?>

Jeg ville nok ændre din type for date i din tabel i databasen til datetime i stedet for varchar. Det er meget svært at sortere på en varchar.

closed