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

No comments posted yet

Your Answer:

Login to answer
333 Like 33 Dislike
Previous forums Next forums
Other forums

void* and sizeof()
Hi,

Using void* and sizeof is it possible to get the value of the object ?

I understan

Coding question?
Hey guys, I have a quick question. If I want to make a way for people to pay for health in my game,

How to make URL loads only on login
On my page, when a user login he's redirects to user_home.php. I made it also to open the chat scree

Help building / using array
First - this is a cross-posting, if this is wrong I apologise! What started out as a MySQL query que

PHP webpage & array print issue
I have this code running, and it works perfectly … however, see my bottom bit about what I see

Using real time in php
I'm very average at PHP and im looking to introduce time to something on my site.
Its a sports si

asking for direction
I have 2 tables in my data, which are "post" and "event"
I won't make a summa

Function
How can I make this function that once you click the link in the code it takes you to a new page wit

php mailer
How can i send a mail to large no, say 50,000 reciepients using [color=#0000FF]php mailer[/color]

please fix the error
What is the error in the below code ???
Line number On/Off | Expand/Contract <?php

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash