alphabetical pagination a to z

[wright67uk]

What would be the best way to make an alphabetical pagination list of MySQL results?

 

eg.

 

A | B | C | D | E

 

would I simply need to assign GET variables to each letter, and then process the GET in a MySQL select?

 

eg.

 

<a href="page.php?letter=a>A | </a>

<a href="page.php?letter=a>B | </a>

<a href="page.php?letter=a>C | </a>

 

<a href="page.php?letter=a>D | </a>

 

<a href="page.php?letter=a>E | </a>

 

I'm sure there is a more efficient way?

 

 

 

[PravinS]

This will help you

<?php
	//For A - Z (Capital letters)
	for($c=65;$c<=90;$c++)
	{
		echo '<a href="page.php?letter='.chr($c).'">'.chr($c).'</a>';
	}
	
	//For a - z (Small letters)
	for($c=97;$c<=122;$c++)
	{
		echo '<a href="page.php?letter='.chr($c).'">'.chr($c).'</a>';
	}
?>

[mac_gyver]

http://forums.phpfreaks.com/topic/277366-help-trying-to-create-a-dynamic-browse-by-page/?do=findComment&comment=1426892