Displaying a database result all caps?

Discussion in 'PHP' started by mokimofiki, Aug 21, 2009.

0
  1. #1
    How do you display database entries in all caps even if they are stored lowercase?

    example:

    in database: sdr-123
    display: SDR-123
     
    mokimofiki, Aug 21, 2009 IP
  2. kishore415

    kishore415 Well-Known Member

    Messages:
    1,462
    Likes Received:
    41
    Best Answers:
    0
    Trophy Points:
    160
    #2
    Use strtoupper()....this will solve your issue...
     
    kishore415, Aug 21, 2009 IP
    mokimofiki likes this.
  3. mokimofiki

    mokimofiki Well-Known Member

    Messages:
    444
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    130
    #3
    Thank you that works perfect
     
    mokimofiki, Aug 21, 2009 IP
  4. kalinchuk

    kalinchuk Peon

    Messages:
    11
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    In your mysql query, you can try selecting a column with UPPER(column_name)
     
    kalinchuk, Aug 23, 2009 IP