Browsing by Letter

[La_Parka]

How can one create a "browse by letter" option for data from a MYSQL DB, like A | B | C | ....and so on, where each letter only brings up records that start with that letter?

[Weedpacket]

My guess would be something like ".... WHERE search_field LIKE 'a%'" or 'b%' or 'c%' - where 'a', 'b', 'c' is of course the letter to search on.

[jpmoriarty]

FYI I use this to auto generate an alphabet for me:

$alpha = 65;

while($alpha <= 90)
{
  echo chr($alpha)."<br>";
  $alpha++;
}

so you could tinker with it to include hyperlinks for each letter which will modify the sql to look for that letter as advised above etc.