Thanks for helping! > So you ARE having problems trying to change your sbj_count and > hsp_count columns after adding information to your table your so that > data is re-ranked according to some rule(s) you have. Exactly, how do > you determine the new ranking? I could make a guess based on your > data but I would probably be wrong. > > Walk me through this process, please. I give you these data points: > (sbjname, score): (a,500), (a,900), (b,800), (c,500), (c,600), > (c,700), (d,400), (d,1000), (e,500), (e,900), (f,700), (g,600) > > Could you please explain to me how to generate(create) the sbj_count > and hsp_count values for each row? As I said, I can probably guess but > I want the "official" method from you. I can help you write the SQL to > do it but I need to know what you need to do.
Both the old and new ranking are based on score values. The highest score get the lowest sbj_count, but sbj_names must be ordered next to each other (a a b b c c etc) with ascending hsp_count values. Thus, (sbj_count,sbjname, score,hsp_count) (1,d,1000,1) (1,d,400,2) (2,a,900,1) (2,a,500,2) (3,e,900,1) (3,e,500,2) (4,b,800,1) (5,c,700,1) (5,c,600,2) (5,c,500,3) (6,f,700,1) (7,g,600,1) Hope that helps... Regards, Marcus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]