php alphabet list

[Bernie]

Hi,
I have a list of movies displayed with the letters a-z on top of page. I
would like to press a letter and get the corresponding list of movies
starting with the chosen letter. How do I go about doing this. Any help
would be appreciated. Using PHP and Mysql with Dreamweaver MX . Thanks
Bernie

[Tobias Schlemmer]

On Thu, 7 Oct 2004 08:15:13 +1000, Bernie <bernie@znservices.com> wrote:

> Hi,
> I have a list of movies displayed with the letters a-z on top of page. I
> would like to press a letter and get the corresponding list of movies
> starting with the chosen letter. How do I go about doing this. Any help
> would be appreciated. Using PHP and Mysql with Dreamweaver MX . Thanks
> Bernie
>
>

Hi,
So you can use 0-9, A, B, C, ... Z.
To create a list form A to Z use the php range function and merge them
together with 0-9:
$arrList = array_merge(array('0-9'), range('A','Z'));
foreach ($arrList as $value) {
echo '<a href="http://example.com/alphabet.php?letter=' . $value . '">' .
$value . '</a>&nbsp;';
}


Now, you can call your webpage with the corresponding link e.g
[url]http://example.com/alphabet.php?letter=A[/url]
And your MySQL goes like this:
SELECT *
FROM movies
WHERE movie_name REGEXP '^[" . $_GET['letter'] . "]';

If no letter is selected, you will get the whole list.

But i dont known how it looks in Dreamwearver.