Skip to results by clicking letter in alphabet

MitchEvans

I have many results on a page, I want a user to be able to click on the letters of the alphabet and then the browser will take you to the part of the page where the results begin with that letter.

This is my code so far, stuck from here though:

echo"<center><TABLE WIDTH='565'> 
		  <TR> 
			 <TD ALIGN='CENTER'><FONT FACE='Arial' SIZE='-1' COLOR='#000066'><B><A
				HREF='#a'>A</A> / <A HREF='#b'>B</A> / <A HREF='#c'>C</A> / <A HREF='#d'>D</A>
				/ <A HREF='#e'>E</A> / <A HREF='#f'>F</A> / <A HREF='#g'>G</A> / <A
				HREF='#h'>H</A> / <A HREF='#i'>I</A> / <A HREF='#j'>J</A> / <A HREF='#k'>K</A>
				/ <A HREF='#l'>L</A> / <A HREF='#m'>M</A> / <A HREF='#n'>N</A> / <A
				HREF='#o'>O</A> / <A HREF='#p'>P</A> / <A HREF='#q'>Q</A> / <A HREF='#r'>R</A>
				/ <A HREF='#s'>S</A> / <A HREF='#t'>T</A> / <A HREF='#u'>U</A> / <A
				HREF='#v'>V</A> / <A HREF='#w'>W</A> / <A HREF='#x'>X</A> / <A HREF='#y'>Y</A>
				/ <A HREF='#z'>Z</A></B></FONT></TD> 
		  </TR> 
		</TABLE> 
		<TABLE WIDTH='565'></center>";

Its the $Item that the alphabet will look for, this $Item loops showing many items my code for this is:

echo"<td>$Item</td>";

shmusie

You need to do something like

<?php echo "<td><a name=\"".substr($Item,1,1)."\" /></td>"; ?>

Note there's lots of ways to output the HTML - dice it the way you like it
http://uk2.php.net/manual/en/function.substr.php

Otherwise you have no anchor point for the link to go to.
Susie.

Installer

You could try something like this (untested, first draft):

$data_table = '<center><table width="565">';
while ($row = mysql_fetch_assoc($result)) {
    $first = strtolower(substr($row['item'], 0, 1));
    if (!in_array($first, $alpha)) {
        $first_ltrs[] = $first;
        $data_table .= '<tr id="' . $first . '">';
    } else {
        $data_table .= '<tr>';
    }
    $data_table .= '<td>' . $row['item'] . '</td>'
                .  '<td>' . $row['whatever_else'] . '</td>'
                .  '</tr>';
}
$data_table .= '</table></center>';

$link_table = '<center><table width="565">' 
            . '<tr><td align="center">'
            . '<font face="arial" size="-1" color="#000066">';
foreach (range('a', 'z') as $ltr) {
    if (in_array($ltr, $first_ltrs)) {         

        $link_table .= '<b><a href="#' . $ltr . '">' . $ltr . '</a></b> / ';
    } else {
        $link_table .= $ltr . ' / ';
    }
}
$link_table = rtrim($link_str, ' / ');
$link_table .= '</font></td></tr></table></center>';

echo $link_table . $data_table;

You should also look into using css.