Very Difficult But Could Be Simple Question

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • neewguy
    New Member
    • Mar 2007
    • 1

    Very Difficult But Could Be Simple Question

    Hi

    I want to show only one instance of many things. For example, the word "CAR" is repeated 5 times in one column of MYSQL. So I want to show "CAR" only one time, not 5 times. What formula do I use to show that way in PHP?

    When the word "CAR" is entered again into that column, it should still show only one "CAR"!!

    There are many repeated words that needs to taken carer of

    HELP, the whole internet doesnt know it!!
  • Motoma
    Recognized Expert Specialist
    • Jan 2007
    • 3236

    #2
    Originally posted by neewguy
    Hi

    I want to show only one instance of many things. For example, the word "CAR" is repeated 5 times in one column of MYSQL. So I want to show "CAR" only one time, not 5 times. What formula do I use to show that way in PHP?

    When the word "CAR" is entered again into that column, it should still show only one "CAR"!!

    There are many repeated words that needs to taken carer of

    HELP, the whole internet doesnt know it!!
    Check out the GROUP BY MySQL command.
    You could also use SELECT DISTINCT, but that is only useful in special cases.

    Comment

    Working...