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 .='' . $A['category'] . '
'; $titles = DB_query("select DISTINCT title,url 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 .='' . $B['title'] . ' 
'; // $retval .= ''. $B['title'] . '
'; // $retval .= 'URL ='. $url . '
'; } } $retval .= '
'; } } else { $retval .= $LANG10[21]; } return $retval; }