Dates Problem for weblinks section in php nuke - any help?

[Souljah]

Hi,

I cant get my php nuke to display links with the 'date added' correctly, and subsequently the 'NEW' boxes that appear for new links do not appear.....anyone know whats wrong?

Heres and example.....
(Added on: 23-àïð-2003)

Can anyone tell me what may be wrong?

thanks for any help

greg

[FrozNic]

show us the code

[Souljah]

Well this is all I could find in the 'index' for the weblinks section.....
Tell me if something doesnt add up.....
thanks

function NewLinksDate($selectdate) {
global $prefix, $dbi,$admin;
$admin = base64_decode($admin);
$admin = explode(":", $admin);
$aid = "$admin[0]";
$result3 = sql_query("select radminlink,radminsuper from ".$prefix."authors where aid='$aid'", $dbi);
list($radminlink,$radminsuper) = sql_fetch_array($result3, $dbi);
$dateDB = (date("d-M-Y", $selectdate));
$dateView = (date("F d, Y", $selectdate));
include("header.php");
menu(1);
echo "<br>";
OpenTable();
$newlinkDB = Date("Y-m-d", $selectdate);
$result = sql_query("select * FROM ".$prefix."links_links WHERE date LIKE '%$newlinkDB%'", $dbi);
$totallinks = sql_num_rows($result, $dbi);
echo "<font class=\"option\"><b>$dateView - $totallinks ".NEWLINKS."</b></font>"
."<table width=\"100%\" cellspacing=\"0\" cellpadding=\"10\" border=\"0\"><tr><td><font class=\"content\">";
$result=sql_query("select lid, cid, sid, title, description, date, hits, linkratingsummary, totalvotes, totalcomments from ".$prefix."links_links where date LIKE '%$newlinkDB%' order by title ASC", $dbi);
while(list($lid, $cid, $sid, $title, $description, $time, $hits, $linkratingsummary, $totalvotes, $totalcomments)=sql_fetch_row($result, $dbi)) {
$linkratingsummary = number_format($linkratingsummary, $mainvotedecimal);
$title = stripslashes($title); $description = stripslashes($description);
echo "<a href=\"modules.php?name=Web_Links&l_op=visit&amp;lid=$lid\" target=\"new\">$title</a>";
newlinkgraphic($datetime, $time);
popgraphic($hits);
echo "<br>"._DESCRIPTION.": $description<br>";
setlocale ("LC_TIME", "$locale");

[Souljah]

anyone?

Please its really bugging me and I dont know where to start.....

[FrozNic]

where's the part where it prints
Heres and example.....
(Added on: 23-àïð-2003)

oh, and for future refrence, when u type php code... type it inside these -> [ php] $phpcode [ /php] <- tags

bigger examp:
[ php]
if (1=1)
{
print 'hi';
}
else
{
print 'bi';
}
[ /php]