1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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