Only show posts begining with letter

[ade_dnb]

How would I only show posts in forum beginning with selected letter like the memberlist has?

So at the top above all the posts you would have...

[#] [A] [B] [C] [D].............etc

When user clicks on letter, it will only display posts beginning with that letter.

Any help on this would be grateful. Thanks

[Dismounted]

I have not seen a modification for this, put the query that fetches them would probably be pretty simple.

[ade_dnb]

Originally Posted by Dismounted

I have not seen a modification for this, put the query that fetches them would probably be pretty simple.

Thanks for replying. Could you explain that a little more. Im not experienced in this.

[Dismounted]

Replicate how member.php generates the letters, and then just run queries:
[sql]SELECT *
FROM post
WHERE pagetext LIKE 'A%'[/sql]

[ade_dnb]

Originally Posted by Dismounted

Replicate how member.php generates the letters, and then just run queries:
[sql]SELECT *
FROM post
WHERE pagetext LIKE 'A%'[/sql]

Thanks for the explanation. Im going to investigate this now.