Display all database results with URL variable?

[cwhazzoo]

Hi,

I am using PHP MySQL

I have a database that is Alphabetically ordered. I am trying to create a dynamic page that will only show A, B, C, ... and so on. I do this by Creating links named after the letters in the Alphabet. I have a recordset that filters the table using a URL variable that uses Type. Unfortunately when I click on the link it only displays the first record that contains an A. Not all the records that contain  A.

For example:

I have a link that is just "A". Its link is ?Type=A. In the database table their are 3 records that contain A under Type, but when I click on it only one record containing A is displayed. I hope you are following this.

If you want a direct reference to what I am doing go to:

http://cwhazzoo.com/gamelinktesting.php

This is how my database is designed:

ID (primary key)	Name	Letter
0001	Example A	A

I want to be able to show only the selected letter of records using only one page. Thanks!

[bregent]

Are you using a DW repeating region, or some other method that will loop through the recordset and output all rows?

[cwhazzoo]

I am using DW and the dynamic text feature. Should I use the repeat region?

[bregent · Accepted solution]

>Should I use the repeat region?

Yep. That's what it's for.