jump to letter in paginated results?

viveleroi0

I'm on a project that has paginated results coming from MySQL, say ten records on a page. Let's say that the results contain a song title. What would be the best method for me to write a script that could take a user to whichever page has the first song title starting with B?

Basically, the client wants a list of letters at the bottom that take the user to the page that records beginning with the selected letter begin on.

Advice? Am I going to have to loop through the results and count the positions of the letters, and then calculate which page that position would be on?

leatherback

nope..

use a "select * from songs where songname like '".$letter."%'";

viveleroi0

leatherback wrote:
nope..

use a "select * from songs where songname like '".$letter."%'";

That's the problem, I can't re-query the database - I need to display all records, ten results per page. That's fine, no prob, I've been doing this for seven years.

I need a link for every letter of the alphabet on each search page that acts like "jump to page #" box - instead of entering your page number you would click a letter - the system needs to then take you to the page that actually has the first result beginning with that letter.

The query has to stay the same, the only difference is the LIMIT that will move the user to a different portion of the results.

scrupul0us

i guess this begs the question... why CANT you re-query the database?

dagon

something like:


$first_letter = mb_substr($row['sort_title'], 0, 1);
		if ($tmp != $first_letter) {
			$tmp = $first_letter;
			$page_content_li .= '<h3 id="'.$tmp.'">'.$tmp.'</h3>';
			$page_content_az .= '<a href="#'.$tmp.'">'.$tmp.'</a> ';
		}

will give you the a-z for a sub menu and the per letter heading for the page. This was a direct cut and past from one of my sites so you need to change the vars.