Top 100 script problem : PHP + MySQL

Anon

Hi.
I am trying to make a 'TOP 100' keywords script for my search engine, which launches in a few months.
I have a system in PHP + MySQL which logs all teh keywords that have been searched for, and adds to their popularity every time they are searched for.

Now, I would like to display a 'TOP 100' which allows users to scroll through all the top searches, ordered by popularity.
This is easy enough, as it is just a matter of limiting it to 100, and 'ORDER BY' popularity. I can do that easily.
But what I would like to do, is display a sort of results page menu:

1-19 20-39 40-59 60-79 80-100

I can do a page system easily, with values of Page 1, Page 2, Page 3, Page 4 etc...
But I would like to know how to produce the correct numbers i.e. 1-19, using the least code possible.

What I have so far is: (it probably needs scraping, I haven't been doing PHP for long, and it shows )

code:--------------------------------------------------------------------------------<table>
<?php
mysql_connect("localhost", "root", "");
mysql_select_db("eliter");

$limit = 20;
$numrows = 100;

if (!isset($offset)) $offset=0;

$result = mysql_query("SELECT * FROM keywords ORDER BY popularity DESC LIMIT $offset, $limit");

echo("<tr><td>");

while ( $details = mysql_fetch_array($result) ) {

$keyword = $details["keywords"];

echo("
$num. <a href='http://www.eliter.com/servlet/search?query=$keyword&where=web'>$keyword</a> 
");
}

if ($numrows > $limit) {
// calculate number of pages needing links
$pages=intval($numrows/$limit);
// $pages now contains int of pages needed unless there is a remainder from division
if ($numrows%$limit) {
// has remainder so add one page
$pages++;
}
print ' Top 100 Keywords:  ';

//Create the links

for ($i=1; $i <= $pages; $i++) { // loop thru
$newoffset=$limit*($i-1);

if ($newoffset != $offset) {
printf(' <a href="%s?offset=%s">%s</a> ', $PHP_SELF, $newoffset, $i, "");

} else {
$lastresult=($newoffset-1)+$limit;
$firstresult = $lastresult-19;
print "  $firstresult - $lastresult ";

}
}
}
?>

</table>--------------------------------------------------------------------------------

You can see how I have tried..
Also, what I am having a problem with, is giving each result a number according to where they are in the top 100.
I tried the for statement, but couldn't get it to work with the while statement.
CAn anyone offer any help?

Thank alot.
AJ

Anon

So you need a piece of code that generates the numbers 1,20,40,60 and 80
well the first time you just use 1, and the rest is

for ($t=20;$t<80;$t=$t+20)
{
print $t;
};

If you lateron decide to change the number of results per page, replace 20 by a variable, and replace 80 by the starting number of the last page,
like (420) or (($number_of_pages-1)$results_per_page).

Anon

Vincent, thanks very much for your help, and although I understand what you are getting at, I don't know how to implement it.
I am only a complete beginner, at 3 weeks PHP programming, from one simple tutorial.

I can't even figure out how to assign number to each result.. i.e. 1 = most popular
2= second most popular
3= third most popular .. etc!

So if anyone could help me by showing me how to implement it, that would be great.
Thanks again.
-AJ

Anon

All you need is to get results x to y right?

SO, you use the LIMIT statement.

SELECT * FROM table WHERE bla LIMIT x,y;

this fetches the next y results, starting at result x.

So if you want to get page 20-39, you enter:

SELECT * FROM table WHERE bla LIMIT 20,20;

If you use the loop I posted before, you can easily print urls to a script
that executes this query, like this:

for ($t=20;$t<80;$t=$t+20)
{
print "<a href=get_pages.php?starting_at=$t&number_of_pages=20>$t</a>";
};

Then in your "get_pages.php" script you can put the "starting_at" and "number_of_pages" into the sql statement.

Anon

heh.