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

Form always sends to error page...
Hello,
Any help will be greatly appreciated. I am having trouble getting multiple fields to be re

mysq_num_rows
Hi,

I want to use:

Code: if(mysql_num_rows($ergebnis2)==2)
how can the value 2, be

elseif help!
OK so I'm new to the site, as well as PHP altogether (Trying my hand at managing an online RPG) and

background color imagefill
Hello

I would like to ask you why I see this square in red color just in my local xampp insta

Setting condidtions for an input box
Hi all,

I would like to set a condition in a txt box that says the number a user enters has t

Program with calculate Meteorologic measurements
Hello I'm a beginner and I want to make a program with calculate Meteorologic measurements:
ba

Text to picture Generator
Hello, i have found this script and it works really good^^ But i have one problem, i would like to c

Different actions for different parts of a string
<?php
function dosomething($string, $else = '') {
if (empty($else))
$string

unexpected T_STRING
error log "[Sat Jan 09 18:27:58 2010] [error] [client 127.0.0.1] PHP Parse error: syntax error

How to pass parameter to tag query?
Hi,
I want to get the value of a tag at a specific time (like 10/27/09 15:29:59), I need to giv