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

pull content
I have an existing page, domain/adverts.php which has a good PR. I've just rebuilt my site and the n

Question about GD library
I am trying to make an image that shows a random quote from my database.


However I want t

Phase Error I can't seem to find :(`
Hey guys, I can seem to find my phase error on this. I am getting this error

[error]
Pars

If statement help please.
Hello on my site I have 2 content boxes. 1 is for the main content (which is the biggest one) and th

How to kill asynchronous postback / current postback?
Hi,here is my problem:I have a web site with many pages of which some may take time to process resul

Stopping page post back
I have few literal contriols in my page and a repeater too. But inspite of using update panel, postb

form problem
below in the form action, i've put "test.php?w=$sw&h=$sh" but when i input the for

Call to undefined function mysql_fetch_accoc()
New to php/mysql coding. What's wrong with this sequence, or am I
just not seeing to obvious?

Intrastat Report Config in ECC 6.0 - goods Movement in EU countries
Colleagues, need ur help to understand the changes require in ECC 6 standard Report configuration se

MySql timezone
Code: $sql = "SELECT *, date_format(date, '%m/%d/%Y at %I:%i %p' )as date FROM comments WHERE t