ignoring duplicates

[ukscotth]

Hi,

 

I have a database table which is full of books e.g book_title, book_author, book_date etc.  Im trying to work out a way to list all the authors without duplicating them, if that makes sense.

 

If I do a simple query and then display the book_author in a loop it will show multiple entries for each author.

 

I just want it to display each author once.

 

Hope that makes sense lol sorry Im a newbie.

 

Anyone know how I can do it ?

 

Thanks in advance,

 

Scott.

 

 

[WebStyles]

select distinct `author` from `table_name` order by `author`

[ukscotth]

Thanks alot webstyles, il give it a try

[ukscotth]

works perfect. Thanks again.