Get content from table into a list, without repeating.

Posted on 16th Feb 2014 07:03 pm by admin

Alright this is kinda an odd thing, so I need some help.

I have a table "quote" with the three columns `id`, `quote`, and `author`.

Now I am wondering if there is anyway that I can output all the different values in the column `author`, and if a repeat is found, not to display it again.

I know I can do this in a for loop, but I know there is a better way to do it. Always is.

Any help or suggestions are always greatly appreciated.

Thanks in advanced

Your Answer:

Login to answer

Other forums

javascript in php code causes page to display white
Hi All,

Odd one this, I've got the following code (below) which is a simple log in form. The

PHP referral database. I would like this form to email the referrer.
Okay, Hello I've been trolling for years. This the first time I've ever asked for php help. Normally

When i am Canseling the Billing Document in VF11 I am getting Shortdump
Hi Experts

When i am Canseling the Billing Document in VF11 I am getting Shortdump.

Passing vars to the DB
I have 3 small testing tables:

ID TYPE
1 pepperoni
2 C. bacon
3 taco

ID TY

Undefined variable: adHTML
Hello:

While checking my site error logs, I've noticed one repetitive error that fills the lo

Mail form doesn't send Russian/Cyrillic characters correctly?
When someone enters foreign characters (like Cyrillic text, and Japanese/Chinese probably gives the

IS Retail & Manufacturing
Hi

Can IS Retail and Manufacturing activities be done in same instance ie. in same client

Multiple WHILE loops help
Hi there. I'm writing an application that is pulling and displaying results for real estate listing

Need help/w Page: 1,2,3,4 function!
So I have this code im working on where it's ment to display seperate pages having 20 logs each
I

gettext translates ALWAYS?
I'm using gettext with the new version of XAMPP (5.3.0) on Windows Seven RTM (build 7600)
gettext