Latest news panel

[adnann]

hi

I have instaled a latest news panel on my site but I want it to show news from one category and to show the news with picture

 

<?php
/*---------------------------------------------------+
| PHP-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright © 2002 - 2007 Nick Jones
| http://www.php-fusion.co.uk/
+----------------------------------------------------+
| Released under the terms & conditions of v2 of the
| GNU General Public License. For details refer to
| the included gpl.txt file or visit http://gnu.org
+----------------------------------------------------+
| latest_news_panel by flyingduck
| Shows latest newslinks in a panel
| http://www.flyingduck.dk
+----------------------------------------------------*/
if (!defined("IN_FUSION")) { header("Location: ../../index.php"); exit; }

openside($locale['046']);
$result = dbquery("SELECT * FROM ".$db_prefix."news ORDER BY news_datestamp DESC LIMIT 0,10");
if (dbrows($result) != 0) {
while ($data = dbarray($result)) {
	$itemsubject = trimlink($data['news_subject'], 23);
	echo "<img src='".THEME."images/bullet.gif' alt=''> <a href='".BASEDIR."news.php?readmore=".$data['news_id']."' title='".$data['news_subject']."' class='side'>$itemsubject</a><br>\n";
}
} else {
echo "<center>".$locale['047']."</center>\n";
}
closeside();
?>

[cooldude832]

well since no one knows your database scheme the best we can say is

 

$result = dbquery("SELECT * FROM ".$db_prefix."news ORDER BY news_datestamp DESC LIMIT 0,10");

 

add a where clause to this query that best reflects what you need.

[adnann]

sorry I dont really understand can you be more specific

thanks

[cooldude832]

sorry I dont really understand can you be more specific

thanks

 

Thats your problem you aren't giving us anything to work with.

[craygo]

if your table has a category field use that in a where clause.

 

Example:

in your news table there is a field called "category" you can set a category name or id and look for that

$category = '1';
$result = dbquery("SELECT * FROM ".$db_prefix."news WHERE `category` = '$category' ORDER BY news_datestamp DESC LIMIT 0,10");

 

Ray

 

[adnann]

what do you need to work with??

[revraz]

This should really be in the 3rd party scripts area since you are not the author of the code.

[adnann]

can any one help me plz?