By johnhanley on

Using pager_query has anyone ever thought about a list of alphabetical links ("A, B, C...") versus the current numeric pages?

The idea is this. First get a DISTINCT list of letters from a name or title table field. When outputting the entire alphabet only the letters with existing records would be hyperlinked. Each link would jump to the first page of the first entry of the corresponding letter.

This is quite common. dexonline.com for example.

Comments?

⋅ Categories: Drupal 4.6.x

Comments

michaelangela’s picture

michaelangela commented

Do you mean something along the lines of this?

http://drupal.org/node/18354

or more customizable?

--------------------
Michael
http://michaelangela.name

johnhanley’s picture

johnhanley commented

Thanks for the referral.

This might have done the trick, but unfortunately it's tied specifically to node data.

I need something more generic that'll create a alphabetical index from any recordset.

I'm going to create my own custom function and this might serve as good reference although my approach will be to use one query to retrieve all the records in one pass instead of querying one letter at a time.

michaelangela’s picture

michaelangela commented

I see what you mean, i.e. around line 99 with the foreach loop there. We are pondering a solution that also works regardless of the language and that would certainly be a limiting factor.

--------------------
Michael
http://michaelangela.name