Posted on: 07/10/02 04:14am
By: Euan
Posted on: 07/12/02 04:40am
By: Kybla
Posted on: 07/12/02 04:50am
By: Kybla
Posted on: 07/21/02 05:53pm
By: Anonymous (Anonymous)
Posted on: 09/22/02 03:32pm
By: Anonymous (Anonymous)
Posted on: 05/18/04 11:24pm
By: ScurvyDawg
Tue May 18 20:20:53 2004 - 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '> 0 ORDER BY hits desc LIMIT 10' at line 1. SQL in question: SELECT lid,url,title,hits from gl_linksWHERE hits > 0 ORDER BY hits desc LIMIT 10
function phpblock_topLinks() { global $_TABLES, $_CONF, $LANG10; $retval .= "<p><table width="100%" border="0">n"; $retval .= "<tr><td><b>Site Name</b></td><td><b>Hits</b></td></tr>"; $result = DB_query("SELECT ID,SiteName,SiteURL,HitsOut from {$_TABLES['pllinks']} WHERE HitsOut > 0 ORDER BY HitsOut desc LIMIT 0, 10"); $nrows = DB_numRows($result); if ($nrows > 0) { for ($i = 0; $i < $nrows; $i++) { $A = DB_fetchArray($result); $retval .='<tr><td><a href="' . $_CONF['site_url'] . '/phplinks/out_frame.php?&ID=' . $A['ID'] . '">' . $A['SiteName'] . ''; $retval .='</a></td><td>' . $A['HitsOut'] . '</td></tr>'; } } else { $retval .="<tr><td align="center">"; $retval .= $LANG10[21]; $retval .="</td></tr>"; } $retval .="</table><p>"; $retval .="<center>"; $retval .= '<a href="' . $_CONF['site_url'] . '/phplinks/index.php">More Links</a>'; $retval .="</center>"; return $retval; }
Posted on: 05/19/04 03:41am
By: jmichael
Posted on: 05/19/04 09:26pm
By: ScurvyDawg
function phpblock_topLinks() { global $_TABLES, $_CONF, $LANG10; $retval .= "<p><table width="100%" border="0">n"; $retval .= "<tr><td><b>Site Name</b></td><td><b>Hits</b></td></tr>"; $result = DB_query("SELECT ID,SiteName,SiteURL,HitsOut from {$_TABLES['pllinks']} WHERE HitsOut > 0 ORDER BY HitsOut desc LIMIT 0, 10"); $nrows = DB_numRows($result); if ($nrows > 0) { for ($i = 0; $i < $nrows; $i++) { $A = DB_fetchArray($result); $retval .='<tr><td><a href="' . $_CONF['site_url'] . '/phplinks/out_frame.php?&ID=' . $A['ID'] . '">' . $A['SiteName'] . ''; $retval .='</a></td><td>' . $A['HitsOut'] . '</td></tr>'; } } else { $retval .="<tr><td align="center">"; $retval .= $LANG10[21]; $retval .="</td></tr>"; } $retval .="</table><p>"; $retval .="<center>"; $retval .= '<a href="' . $_CONF['site_url'] . '/phplinks/index.php">More Links</a>'; $retval .="</center>"; return $retval; }
Posted on: 05/20/04 11:58am
By: ScurvyDawg
Posted on: 05/23/04 09:38am
By: jmichael
Posted on: 05/23/04 12:26pm
By: ScurvyDawg
Posted on: 05/24/04 02:45am
By: destr0yr
function phpblock_topLinks() { global $_TABLES, $_CONF, $LANG10; $retval .= '<p><table width="100%" cellspacing="1" cellpadding="1" border="0">' . LB; $retval .= '<tr><td><b>Site Name</b></td><td><b>Hits</b></td></tr>' . LB; $sql = DB_query("SELECT ID,SiteName,SiteURL,HitsOut from {$_TABLES['pllinks']} WHERE HitsOut > 0 ORDER BY HitsOut desc LIMIT 0, 10"); $nrows = DB_numRows($sql); if ($nrows > 0) { for ($i = 0; $i < $nrows; $i++) { $A = DB_fetchArray($sql); $retval .= '<tr><td><a href="' . $_CONF['site_url'] . '/phplinks/out_frame.php?&ID=' . $A['ID'] . '">' . $A['SiteName'] . LB; $retval .= '</a></td><td>' . $A['HitsOut'] . '</td></tr>' . LB; } } else { $retval .= '<tr><td align="center">' . LB; $retval .= $LANG10[21]; $retval .= '</td></tr>' . LB; } $retval .= '</table><p>' . LB; $retval .= '<div align="center">' . LB; $retval .= '<a href="' . $_CONF['site_url'] . '/phplinks/index.php">More Links</a>' . LB; $retval .= '</div>' . LB; return $retval; }