hi there,
i know about round robin because of chess tournaments.
it is like everybody against everybody, but in chess is double turn because once you play as white and one more time as black with every single opponent.
i know round robin algorithms exist.
there are also round robin schheduling algorithms.
i think you should look at one already made, but maybe in another programming language.
please, look at these web searches:
http://www.google.com/#hl=en&sugexp=pfwl&cp=25&gs_id=au&xhr=t&q=round+robin+tournament+algorithm&pq=round+robin+algorithm+sql&pf=p&sclient=psy-ab&pbx=1&oq=round+robin+tournament+al&aq=0&aqi=g1g-v2g-b1&aql=&gs_sm=&gs_upl=&bav=on.2,or.r_gc.r_pw.r_qf.,cf.osb&fp=5895f996020e53d9&biw=1280&bih=899
http://www.google.com/#hl=en&sclient=psy-ab&q=round+robin+scheduling+tournament+algorithm&pbx=1&oq=round+robin+scheduling+tournament+algorithm&aq=f&aqi=&aql=&gs_sm=e&gs_upl=13589l15669l8l16567l11l10l0l0l0l9l1009l4872l2-1.0.4.3.0.1l9l0&bav=on.2,or.r_gc.r_pw.r_qf.,cf.osb&fp=5895f996020e53d9&biw=1280&bih=899
and maybe, if you are lucky enough, here might be lying your answer:
http://www.google.com/#hl=en&sugexp=pfwl&cp=28&gs_id=fy&xhr=t&q=round+robin+algorithm+in+sql&pq=round+robin+scheduling+tournament+algorithm&pf=p&sclient=psy-ab&pbx=1&oq=round+robin+algorithm+in+sql&aq=f&aqi=&aql=&gs_sm=&gs_upl=&bav=on.2,or.r_gc.r_pw.r_qf.,cf.osb&fp=5895f996020e53d9&biw=1280&bih=899
the actual searches are:
round robin tournament algorithm
round robin scheduling algorithm
these two are actually google saved searches
but this one is mine
round robin algorithm sql
good luck,
tonci korsano.