arrange rows retrieved from database
Posted: Sun May 03, 2009 6:04 am
in my website ( php , sql ) . i am retrieving certain rows from database table in the descending order of the date .
for eg : my table will look like this .
what i want to do is
i want to leave a space after each group of years.
ie the table should become as follows
how can i do that? somebody <d>pls</d> please give a solution...
for eg : my table will look like this .
Code: Select all
title date
aaaa 16/3/2009
bbbb 15/3/2009
cccc 6/2/2009
dddd 2/12/2008
eeee 1/12/2007
i want to leave a space after each group of years.
ie the table should become as follows
Code: Select all
title date
aaaa 16/3/2009
bbbb 15/3/2009
cccc 6/2/2009
dddd 2/12/2008
eeee 1/12/2007