you could make it just do this:
while ($link = $sth->fetchrow_hashref) {
$total++;
$link_results .= &site_html_link ($link);
}
and of course comment out those other lines..
then up a few lines..
ABOVE:
add
or you can just change the whole prepare statement to
SELECT * FROM Links WHERE isPopular = 'Yes' ORDER BY Hits DESC LIMIT 1000
jerry
Code:
$total = 0; while ($link = $sth->fetchrow_hashref) {
$total++;
$link_results .= &site_html_link ($link);
}
and of course comment out those other lines..
then up a few lines..
ABOVE:
Code:
LIMIT 1000add
Code:
ORDER BY Links.Hits DESCor you can just change the whole prepare statement to
SELECT * FROM Links WHERE isPopular = 'Yes' ORDER BY Hits DESC LIMIT 1000
jerry