By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,751 Members | 1,216 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,751 IT Pros & Developers. It's quick & easy.

Very Difficult But Could Be Simple Question

P: 1
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!!
Mar 1 '07 #1
Share this Question
Share on Google+
1 Reply


Motoma
Expert 2.5K+
P: 3,235
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.
Mar 1 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.