how to make an alpha menu from database?

Discussion in 'PHP' started by mnymkr, Jun 23, 2008.

0
  1. #1
    I would like to make a directory alpha style display

    A | B | C | D

    but only display the letter if there is a field that starts with that letter in my database column


    so instead of having the whole alphabet

    it would be

    A | B | E | Y

    if there were terms apple, butter, eat and yogurt in the database column?
     
    mnymkr, Jun 23, 2008 IP
  2. EricBruggema

    EricBruggema Well-Known Member

    Messages:
    1,740
    Likes Received:
    28
    Best Answers:
    13
    Trophy Points:
    175
    #2
    I don't get your problem...

    Maby you can do ORDER BY field ASC? if you are using MySQL?
     
    EricBruggema, Jun 24, 2008 IP