Show MYSQL records by ABC's

[WebMasterARR]

OK i need some help or hopefully someone has seen a script/code that will do what I want. I have a database of a couple hundred authors, and I want to be able to list bio, from the database, like if someone click on letter B you get all authors with letter B as last name, I know how to make mysql pull the data i was wondering if anyone has a script showing the alaphabet across the bottom of the page etc.

I have one that i can limit the number of records per page, just need to do it by alphabet now...and my coding is not working as i would hope..

Don

[mourisj]

File alphabet.inc:

<?
echo "<table>\n";
echo "<tr>\n";
echo "<td><a href=\"$page?char=A\">A</a></td>\n";
echo "<td><a href=\"$page?char=B\">B</a></td>\n";
echo "<td><a href=\"$page?char=C\">C</a></td>\n";
echo "<td><a href=\"$page?char=D\">D</a></td>\n";
echo "<td><a href=\"$page?char=E\">E</a></td>\n";
echo "<td><a href=\"$page?char=F\">F</a></td>\n";
echo "<td><a href=\"$page?char=G\">G</a></td>\n";
echo "<td><a href=\"$page?char=H\">H</a></td>\n";
echo "<td><a href=\"$page?char=I\">I</a></td>\n";
echo "<td><a href=\"$page?char=J\">J</a></td>\n";
echo "<td><a href=\"$page?char=K\">K</a></td>\n";
echo "<td><a href=\"$page?char=L\">L</a></td>\n";
echo "<td><a href=\"$page?char=M\">M</a></td>\n";
echo "</tr>\n";

echo "<tr>\n";
echo "<td><a href=\"$page?char=N\">N</a></td>\n";
echo "<td><a href=\"$page?char=O\">O</a></td>\n";
echo "<td><a href=\"$page?char=P\">P</a></td>\n";
echo "<td><a href=\"$page?char=Q\">Q</a></td>\n";
echo "<td><a href=\"$page?char=R\">R</a></td>\n";
echo "<td><a href=\"$page?char=S\">S</a></td>\n";
echo "<td><a href=\"$page?char=T\">T</a></td>\n";
echo "<td><a href=\"$page?char=U\">U</a></td>\n";
echo "<td><a href=\"$page?char=V\">V</a></td>\n";
echo "<td><a href=\"$page?char=W\">W</a></td>\n";
echo "<td><a href=\"$page?char=X\">X</a></td>\n";
echo "<td><a href=\"$page?char=Y\">Y</a></td>\n";
echo "<td><a href=\"$page?char=Z\">Z</a></td>\n";
echo "</tr>\n";

echo "</table>\n";
?>

Your current script :
current_script.php
<?
$page="current_script.php";
(.....)
include("alphabet.inc");

$res = "select * from tablename where data like '$char%'";

(...)
?>

This way, you can use your alphabet.inc anywhere you need it; you just have to get the name of the current script in the file itself (I did this here by simply defning it in the variable $page - I guess there are more sophisticated, universally usable ways to do this)

Hope this helps

JJ Mouris