Avatar billede cpccorp Juniormester
23. juli 2005 - 17:07 Der er 10 kommentarer og
1 løsning

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);
}
}
Avatar billede kdjweb Nybegynder
24. juli 2005 - 16:10 #1
du kunne lave underkategorier? så ville det også passe bedre
Avatar billede cpccorp Juniormester
24. juli 2005 - 16:14 #2
??? Jeg vil bare dele dem i 3 kategorier, ovenstående tager kun 1 kategori

Jeg er ikke dus med php, ikke meget ihvertifald
Avatar billede kdjweb Nybegynder
24. juli 2005 - 16:19 #3
det kræver at du kan samligne kategorierne.
Avatar billede cpccorp Juniormester
24. juli 2005 - 16:32 #4
Senior = 1
Ungdom = 2
Oldboys = 3
Klubnyt = 4
news_cat = en af ovenstående numre
Og det er de 3 øverste jeg skal bruge den 1. nyhed fra
Avatar billede kdjweb Nybegynder
24. juli 2005 - 16:39 #5
jeg kan ikke hjælpe dig så. man kan stadig ikke sammenligne dem
Avatar billede cpccorp Juniormester
24. juli 2005 - 16:43 #6
Sammenlign=???? Hvordan mener du
Avatar billede kdjweb Nybegynder
24. juli 2005 - 17:58 #7
kategori:
id - kategori
1 - hold
2 - klub

underkategori:
id - kategori - underkategori
1 - 1 - senior
2 - 1 - ungdom
3 - 1 - oldboys
4 - 2 - klubnyt
Avatar billede cpccorp Juniormester
24. juli 2005 - 18:33 #8
Vil det sige man ikke som i asp kan sige hvis cat = 1 så vis dem
Men der er 2 tabeller...

news_cat
news_cat_id
news_cat_name
news_cat_description
news_cat_image

news
news_id
news_cat
og så de øvrige felter kan du bruge det så
Avatar billede cpccorp Juniormester
24. juli 2005 - 18:36 #9
news_cat og news er tabellerne
Avatar billede cpccorp Juniormester
24. juli 2005 - 18:36 #10
den øverste linie er noget sludder - undskyld
Avatar billede cpccorp Juniormester
20. november 2011 - 13:02 #11
Lukker
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Vi tilbyder markedets bedste kurser inden for webudvikling

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester