Need help for ad rotator

 hi,
 i am making a website in which i hv a concept of adds in that, now i want to use ad rotator in that to show my adds but i hvn't use that befor. plz tell me how to use that with databse and how to i find that which of my add is showing to the users and who click them. i need to get the full details about the add clicked and the adds shown to users. plz tell me the way to do this
 
thank you in advance 

...