Den viser ikke den nyeste nyhed.
Hej;Jeg har følgende kode, til at finde og sortere info fra en tabel. Mit problem er, at den ikke viser den sidste nye nyhed. Dvs. den der står 'øverst' i søgningen:
<div id="center">
<?php
include("topbillede.php");
include("box.php");
include("leftmenu.php");
?>
<!-- Indholdsvinduet -->
<title>Nyhedssektionen</title>
<div id="indhold">
<h1 class="nyhed">Nyhedssektionen</h1>
<?php
include("mysqlconn.php");
/* $num_posts = antallet af nyheder der skal vises pr. side.*/
function newsHandler($num_posts, $type_id)
{
// Antal nyheder, med kategori-typen $type_id
$num_news = mysql_num_rows(mysql_query("select * from nyheder where type_id = $type_id"));
// Hvor skal søgningen starte fra?
$news_index_start = $_GET["news_index_start"];
// Finder de antal nyheder, $num_posts, fra det angivne sted i tabellen, $news_index_start
$current_news = mysql_query("select * from nyheder where type_id = $type_id order by news_create_time desc limit $news_index_start, $num_posts") or die(mysql_error());
// Omdanner resultatet i $current_news til et array og gennmemløber array'et
while ($row = mysql_fetch_array($current_news))
{
if ($num_news < 1)
{
$textNoNews = "Ingen nyheder i denne kategori!";
}
else
{
?>
<table class="nyhed" cellspacing="5">
<tr><th class="nyhed"><?php print "Nyhed - kategori $type_id" ?></th></tr>
<?php
while ($news_info = mysql_fetch_array($current_news))
{
$news_id = $news_info['news_id'];
$headline = stripslashes($news_info['headline']);
$news_text = $news_info['news_text'];
$type_id = $news_info['type_id'];
$hits = $news_info['hits'];
$news_writer = $news_info['news_writer'];
$news_create_time = $news_info['news_create_time'];
?>
<tr><td class="nyhed"><strong><a href=\"shownews.php?news_id=$news_id\"><?php print $headline; ?> </a></strong> <?php print $news_writer; print " $news_create_time, kategori $type_id"; ?></td></tr>
<?php
}
?>
<tr><td></td></tr>
</table>
<?php
}
}
}
newsHandler(4, 1);
newsHandler(4, 2);
newsHandler(4, 3);
?>
</div>
<?php include("rightmenu.php");
?>
</div>
