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

Extracting Long text from message class with parameters
Hi,

I would like to extract the long text from a message class. However, the long text ha

NOOB needs help with upload file
The intent of this form is to create a folder for a client and upload an image into another folder '

Generating unique numbers using php
Hi,
I need help in generating unique number using php.I tired using rand() in php.But, by using r

Change image filetype on upload?
Hi,
I've got a form which uploads an image to the server.
Is it possible to change the image t

preg-match with a string and numbers
Hi, I can't get the expression to work for my preg_match, what I'd like is for it to match the strin

Comment Mod System Effects all rows...
Sorry if its confusing but here is whats going on: I have a table in a database called comments and

MSSQL/PHP
I am tryint to setup a webapplication developed in PHP, Apache2.0 and SQLServer2000 as backend which

Server side $_SESSION
how does one keep the session completely server side. no cookies to the browser at all. i need this

dropdown menu
Hello everbody,

I am php newbie.
I need to develop a program that once click the drop do

Querying info from one table based on info in another
Hi, I am currently trying to make a part for my user driven website where one user can subscribe to