*,distinct

how do i select DISTINCT but * at the same time?

tried:
*,DISTINCT(servername)

and

*,DISTINCT servername

neither works, returns fetch_array error.

but i want to select one DISTINCT row, but also echo other columns.. if i do SELECT DISTINCT A_COLUMN then i can't access the other columns..

Try:

SELECT DISTINCT ON (distinct_column) * FROM tablename;

Think about what you are asking for. Given the following 2 column table, what would your output look like:

server_name other_data
bill data1
bill data2
jack data3
jack data4

A select distinct on the server name would yield 2 rows:
bill
jack

If you try to include the other_data column, you can no longer make it distinct because of the multiple values in the other_data column.