Using the A-Z index on memberlist.php within a forum?

[MarkB]

I love the new A-Z hotlinks at the top of the memberlist, and was wondering if there's a way to use this within a forum? I use a forum for CD reviews, and would love a way for people to be able to jump through the reviews so they can more easily see threads/band names beginning with a particular letter...

[apfeifer]

This would probably be possible, but I'll have to give it more thought tomorrow as I'm going to bed in about 2 minutes. I'll post again tomorrow afternoon after school.

:cool:

[MarkB]

Wickedly cool :cool: Sleep well! ;)

[apfeifer]

Won't be a problem (sleeping, that is)!:p

:cool:

[Freddie Bingham]

Thread titles are not indexed so the query to grab a certain letter are going to grind on a large forum. You could index thread titles to help but that would be an index on a long varchar field so it might affect your performance.

The best solution would be to add a field that contains the first letter only, a 1 char field or an integer field (1 through 26) and place an index on that. Then you set that field when the thread is posted or when the title is changed. Then when someone clicks on A you could do a query on the new field to see what threadids match.

[eva2000]

or just hard code it... don't hit me :)