Pagenav

[Moya]

Hello All

I am working on a music script that list all of the uploaded song onto the page.

This page will list the song title, contributor (username), uploaded date

The problem is the page is getting clustered. As more songs uploaded are displayed just on one page. I am trying to cut down the display in my page and create more page.

Here are what I am looking for

A pagenav that contains all of the letters(from A to Z). If I want to list all songs by the beginning letter, I just click on the letter.

I manage to look into codes on member album hack, but I couldn't figure out. I am a noob in pagination. This album contais join from 2 or more tables whereas my hack only look into the table that I create.

Would you please show me how to a pagination on this hack. Thanks for your help

[Colin F]

Look at the code of the memberslist page.

What you'll have to do is basicly just add a row of links, each with a special var in them, like &letter=A, then on the page check if $_REQUEST['letter'] is set and if it is add a WHERE title LIKE 'A%' to the sql query.
Also, you might want to add letter to the globalize() array.

Hope you understand at least a bit of that

[Moya]

Uhm I am lost with that file. The closest that match my need is the Album.php hack by By velocd

[Moya]

Hi Colin F

I figured out how.

Thanks