[Mysql] Simpel show column name just once?

Hi all,

I have a table like
id | name | descr | sort

Now sort is the column name that needs to display only once. I am using php

SELECT name, descr, sort,  sort as title FROM tbl ORDER BY sort;

Code (markup):

i want title just once for every sort
regards

 

try using distinct()

 

I think its a little ambiguous exactly what you're asking.

 

Hi 123GoToAndPlay

Simply rewrite

SELECT name, descr, sort, sort as title FROM tbl ORDER BY sort;

to

SELECT name, descr, sort as title FROM tbl ORDER BY title;