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

Header is not working in IE
Hi ! header function is not working in IE but it works in FF, Safari, Chrome. any help please. :

EXplanation help
Hey all,

I am still fairly new to PHP programming and I am trying to put together a page wher

Mass activity scheduling
Hi experts,

Im facing some problems to deal with mass activity jobs.
When I run some

Quick Question about echo value
Hey guys, I'm trying to get something to show differently in one of my scripts. I'm trying to make

Help With Showing Users On the Index Page
Ive got this code which works just how i want it to.

Code: <?
$timenow=time();

PHP error on MySQL insert
I'm sure it's the simplest of issues, but I can't recall why this isn't working.

Code: [Selec

Help with simple query
Hi,

I'm trying to do a Query with a Union where I want to print the number of rows $tc conta

How can i use [] tags instead of <> tags for profiles??
On my site im making ive made it so u can register, login and u have a profile which u can update..<

PHP friend keyword equivalent
is there a PHP equivalent for the C++ friend keyword?

Basic Question about Threading and PHP...
I have a page that I am working on and it is taking several hours to process. The basics of what th