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`.

Did you know?Explore Trending and Topic pages for more stories like this.
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

Multipe Dynamic Controls & AutoPostback Issue
I currently have a need to create many dynamic controls (Example Textboxes) that need to do a PostBa

paginate search result
Hi, I have a paginations script to display data from my database but i would like to paginate someon

Parse multirow HTML table
Hello all,
I have a site I am working on. Its a sports site and I am trying to add stats to a DB

socket makes browser hang...
I have a socket server, and I am having a problem at the moment...

A browser sends a http hea

PHP Upload issue
Hi guys,

I have stumble across an interesting issue with my script and is doing my head in.

help with insert
Hi there,

I am trying to insert some data into a database, but for some reason, it is not ins

Edit MySQL Row Using PHP and HTML Form
Hello,

Here's what I'm trying to do. Build a page where a user enters a MySQL row number in.

include problem
I have my root folder as:
Code: $root = $_SERVER["SITE_HTMLROOT"]; // the server root<

Combining refCursors and Summing
Given the following DDL:

CREATE TABLE FOODSALESTEST ("WEEKNBR" NUMBER, "ST

Pspell with my own dictionary
Hello!
I've tested two cases using pspell functions.
1)
Code: $dictionary_link = pspell_new

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