Hi, i m new to this forum and i have seen the members are really helpful, So here is my problem. Actually i m starting up with new site which need to ahce database of banners so please help me to give some nice tips so that i can make good database of banners in less time. Will appreciate all help. Thanks All members and owner of site point. Victory
Sounds like you need a table with 2 fields. one is an auto inc field and the other would be the filename of the graphic image. An auto inc field will automatically increase in value with each new record. You would need to come up with a scheme to choose which ad to play and then acquire that record in the table. Maybe a random seed routine. Or maybe you just want to do them in order. If you do them in order, you would need to keep track of the last ad showed -- which means another table more than likely unless you store it in some global variable on the server. David