Codezwiz >> Forums >> Codezwiz PHP Nuke Help >> CZNews Flash

Register

Hi,

I just installed the CZNews Flash block and would like to change it a little bit. Mine goes backwards....lol. Instead of it showing the newest News post and then going towards the oldest, it shows the oldest news post there is. Would appreciate any help.
Here is the code

$scrolldirection = "left";
$toshow = "30";

global $prefix, $db;
$content = "<table width=\"100%\" border=\"0\">";
$content .= "<Marquee Behavior=\"Scroll\" Direction=\"$scrolldirection\" width=\"100%\" ScrollAmount=\"3\" ScrollDelay=\"30\" onMouseOver=\"this.stop()\" onMouseOut=\"this.start()\">";
$cznf = $db->sql_query("SELECT sid, title, comments, counter from ".$prefix."_stories ORDER BY sid ASC LIMIT 0,$toshow");
while (list($sid, $title, $comments, $counter) = $db->sql_fetchrow($cznf)) {

$content .= "<b>» ;; ;;<font class=\"heading\"><a href=\"modules.php?name=News&file=article&sid=$sid\">$title</b></a> ;; ;; ;;";
}
$content .= "</table>";

Change ORDER BY sid ASC to ORDER BY sid DESC. That should reverse the order.

Register

TYVM Kelly..

RedWolf

YVW.

I installed CZnews flash normally, and worked great..

BUT,

everything seems fine ONLY at Internet Explorer...

At firefox, the WHOLE page resizes to an unkown big size, so the whole front page is bigger than expected, and the result is awful.

Anyone had the same problem ?

Is there a solution ?