PDA

View Full Version : Alphabetical listing how?


ukdeveloper
03-19-2012, 10:54 AM
I want to design a page with a list of users (currently in DBusers) and want the page to look like this:

LIST OF USERS:

A
User 1 (Listed Alphabetically)
User 2 (Listed Alphabetically)
User 3 (Listed Alphabetically)

B
User 1 (Listed Alphabetically)
User 2 (Listed Alphabetically)
User 3 (Listed Alphabetically)

C
User 1 (Listed Alphabetically)
User 2 (Listed Alphabetically)
User 3 (Listed Alphabetically)

etc

Now i know how to create a recordset to pull records beginning with a particular letter from the database and then create a repeat region and inserting it on the page.

My question is, do I need to really create 26 different recordsets (on for each letter) or is there an easier way, remembering i need to list them on the page under headings of letter.

Regards

UKD

edbr
03-20-2012, 01:55 AM
i dont think this is within the scope of dreamweaver's wizard, you will have to research a bit check if conditions and switch try checking the tutorials on tizag.com