Authored by: anonymous on Sunday, April 24 2005 @ 05:56 AM EDT

I' added a little variation with updating of PORTAL hits ;) :
--------------
function phpblock_LinksPage()
{
global $_TABLES, $_CONF, $LANG10;
$result = DB_query("SELECT DISTINCT category from {$_TABLES['links']} WHERE category > '' ORDER BY category DESC");
$nrows = DB_numRows($result);
if ($nrows > 0 )
{
for ($i = 1; $i <= $nrows; $i++)
{
$A = DB_fetchArray($result);
$cat = addslashes ($A['category']);
$result1 = DB_query ("SELECT count(*) AS count FROM {$_TABLES['links']} WHERE category = '{$cat}'");
$D = DB_fetchArray($result1);
$retval .='<b><u>' . $A['category'] . '</u></b><br>';
$titles = DB_query("select DISTINCT title,url,hits,lid from {$_TABLES['links']} WHERE category = '{$cat}' ORDER by title");
$ntitles= DB_numRows($titles);
if ($ntitles > 0)
{
for ($j = 1; $j <= $ntitles; $j++)
{
$B = DB_fetchArray($titles);
$title = addslashes ($B['title']);
$url = addslashes ($B['url']);

$retval .='<a href="/portal.php?what=link&amp;item=' . $B['lid'] . '" target="_new">' . $B['title'] .'</a>&nbsp<br>';


// $retval .= ''. $B['title'] . '<br>';
// $retval .= 'URL ='. $url . '<br>';
}
}
$retval .= '<br>';
}
} else {
$retval .= $LANG10[21];
}
return $retval;
}
--------

[ Reply to This | # ]