i'm not sure if this could be done in SQL itself, i don't think so, so i'll ask here. right. i have 6 columns of data in a MySQL table which i want to group all together, then sort alphabetically, while remembering what row of the table they belong to (i.e. there could be a 7th column, a number, and there'd be 6 pieces of data attahced to that number. help the noob? the alternative would be to have just 2 columns, with each number repeated 6 times. then i could sort them easily in SQL, and not have to resort to PHP. however i'm a little too far down the road to do that...