Vise 1 nyhed i 3 kategorier
jeg her følgende ønske:nedenstående script vil jeg gerne have opdelt således at den/de henter 1 nyhed (den nyeste) fra 3 kategorier og viser dem under hinanden eller ved siden af hinanden.
eller bare lave 1 script som viser 1 nyhed fra 1 kategori som jeg så kan ændre.....Jeg er ingen ørn til php
Scriptet kommer her:
if (file_exists(INFUSIONS."news_cat/locale/".$settings['locale'].".php")) {
include INFUSIONS."news_cat/locale/".$settings['locale'].".php";
} else {
include INFUSIONS."news_cat/locale/English.php";
}
$result = dbquery("SELECT * FROM ".DB_PREFIX."news_cats ORDER BY news_cat_name DESC");
while ($data = dbarray($result)) {
$sel = ($news_cat == $data['news_cat_id'] ? " selected" : "");
$catlist .= "<option value='".$data['news_cat_id']."'$sel>".$data['news_cat_name']."</option>\n";
}
echo "<table width='100%'><tr><td align='right'><form name='news_cat_choose' method='post' action='news.php?category=$news_cat_sel'>
".$locale['NC_001']." <select name='news_cat_sel' class='textbox'>
$catlist</select>
<input type='submit' value='".$locale['NC_002']."' class='button'></form></td></tr></table>";
if (isset($category)) {
$rows = dbcount("(news_id)", "news", "(news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().")");
if (!isset($rowstart)) $rowstart = 0;
if ($rows != 0) {
$i = 1;
$result = dbquery(
"SELECT tn.*, user_id, user_name FROM ".DB_PREFIX."news tn
LEFT JOIN ".DB_PREFIX."users tu ON tn.news_name=tu.user_id
WHERE (news_cat=$news_cat_sel) AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().")
ORDER BY news_datestamp DESC LIMIT $rowstart,10"
);
$numrows = dbrows($result);
while ($data = dbarray($result)) {
$news_subject = "<a name='".$data['news_id']."'></a>".stripslashes($data['news_subject']);
$news_news = stripslashes($data['news_news']);
$getimage = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."news_cats WHERE news_cat_id='".$data['news_cat']."'"));
$news_cat = $getimage['news_cat_image'];
if ($news_cat != "") {
$news_news2 = "<img src='$news_cat' align='right'>" . $news_news;
} else {
$news_news2 = $news_news;
}
if ($data['news_breaks'] == "y") $news_news2 = nl2br($news_news2);
$news_info = array(
"news_id" => $data['news_id'],
"user_id" => $data['user_id'],
"user_name" => $data['user_name'],
"news_date" => $data['news_datestamp'],
"news_ext" => $data['news_extended'] ? "y" : "n",
"news_reads" => $data['news_reads'],
"news_comments" => dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id='".$data['news_id']."'")
);
render_news($news_subject, $news_news2, $news_info);
if ($i != $numrows) { tablebreak(); } $i++;
}
echo "<div align='center' style='margin-top:5px;'>\n".makePageNav($rowstart,10,$rows,3)."\n</div>\n";
} else {
opentable($locale['046']);
echo "<center><br>\n".$locale['047']."<br><br>\n</center>\n";
closetable();
}
}
else if (!isset($readmore)) {
$rows = dbcount("(news_id)", "news", groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().")");
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
if ($rows != 0) {
$i = 1;
$result = dbquery(
"SELECT tn.*, user_id, user_name FROM ".$db_prefix."news tn
LEFT JOIN ".$db_prefix."users tu ON tn.news_name=tu.user_id
WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().")
ORDER BY news_datestamp DESC LIMIT $rowstart,10"
);
$numrows = dbrows($result);
while ($data = dbarray($result)) {
$news_subject = "<a name='".$data['news_id']."'></a>".stripslashes($data['news_subject']);
$news_news = stripslashes($data['news_news']);
$getimage = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."news_cats WHERE news_cat_id='".$data['news_cat']."'"));
$news_cat = $getimage['news_cat_image'];
if ($news_cat != "") {
$news_news2 = "<img src='$news_cat' align='right'>" . $news_news;
} else {
$news_news2 = $news_news;
}
if ($data['news_breaks'] == "y") $news_news2 = nl2br($news_news2);
$news_info = array(
"news_id" => $data['news_id'],
"user_id" => $data['user_id'],
"user_name" => $data['user_name'],
"news_date" => $data['news_datestamp'],
"news_ext" => $data['news_extended'] ? "y" : "n",
"news_reads" => $data['news_reads'],
"news_comments" => dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id='".$data['news_id']."'"),
"news_allow_comments" => $data['news_allow_comments']
);
render_news($news_subject, $news_news2, $news_info);
if ($i != $numrows) { tablebreak(); } $i++;
}
echo "<div align='center' style='margin-top:5px;'>\n".makePageNav($rowstart,10,$rows,3)."\n</div>\n";
} else {
opentable($locale['046']);
echo "<center><br>\n".$locale['047']."<br><br>\n</center>\n";
closetable();
}
} else {
if (!isNum($readmore)) fallback(FUSION_SELF);
include INCLUDES."comments_include.php";
include INCLUDES."ratings_include.php";
$result = dbquery(
"SELECT tn.*, user_id, user_name FROM ".$db_prefix."news tn
LEFT JOIN ".$db_prefix."users tu ON tn.news_name=tu.user_id
WHERE news_id='$readmore'"
);
if (dbrows($result)!=0) {
$data = dbarray($result);
if (checkgroup($data['news_visibility'])) {
if (!isset($_POST['post_comment']) && !isset($_POST['post_rating'])) {
$result2 = dbquery("UPDATE ".$db_prefix."news SET news_reads=news_reads+1 WHERE news_id='$readmore'");
$data['news_reads']++;
}
$news_subject = $data['news_subject'];
$news_news = stripslashes($data['news_extended'] ? $data['news_extended'] : $data['news_news']);
$getimage = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."news_cats WHERE news_cat_id='".$data['news_cat']."'"));
$news_cat = $getimage['news_cat_image'];
$news_news = stripslashes($data['news_extended'] ? $data['news_extended'] : $data['news_news']);
if ($news_cat != "") {
$news_news2 = "<img src='$news_cat' align='right'>" . $news_news;
} else {
$news_news2 = $news_news;
}
if ($data['news_breaks'] == "y") { $news_news2 = nl2br($news_news2); }
$news_info = array(
"news_id" => $data['news_id'],
"user_id" => $data['user_id'],
"user_name" => $data['user_name'],
"news_date" => $data['news_datestamp'],
"news_ext" => "n",
"news_reads" => $data['news_reads'],
"news_comments" => dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id='".$data['news_id']."'"),
"news_allow_comments" => $data['news_allow_comments']
);
render_news($news_subject, $news_news2, $news_info);
if ($data['news_allow_comments']) showcomments("N","news","news_id",$readmore,FUSION_SELF."?readmore=$readmore");
if ($data['news_allow_ratings']) showratings("N",$readmore,FUSION_SELF."?readmore=$readmore");
} else {
redirect(FUSION_SELF);
}
} else {
redirect(FUSION_SELF);
}
}
