thanx guys 4 help even i understand that php is much more flexible to deal with this but i have a very long list of records, alongwith different kind of listings at a time i mean it's something like 7 columns and around 1000 rows and column needs to be summed up, total is displayed at around 15 times so to associate each column and make special SUM() for all, is just so time consuming to execute i thought, it would be much more simpler to use WITH ROLLUP so i turned to this well, and i am getting good results even but only prob is that, i want to display the total count fields in bold, so that user can differentiate it easily but i guess, i shud do something with php itself thanx once again 4 ur time gayatri