I need some help in accomplishing something in perl as i am new in the language.
Im developing a promotional system that basically accepts promotional entries and stores them in a MYSQL db.
Im conducting the promo where the users have to submit unique promo codes as many times as they wish via a CGI web form, the unique code is then stored.
I need to track the number of times a unique user/visitor has submited an entry into a MySQL Db table.
Fields from the table are:
ID FIRSTNAME MIDNAME LASTNAME PROMOTYPE PROMOCODE AGE PHONE EMAIL ADDRESS
I therefore need to find the Most Frequent Participant upto the least Frequent partcipant and their corresponding frequencies using a perl/cgi script.
I already have a developed a script BUT its not reading the Frequencies for each user. You can view it partially working from this URL
Therefore i just need a simple addition of reading EACH users entry and incrementing it everytime then displaying it where labelled No. of times Entered:
NOTE:: Each users entry is unique - so there repetition of users details everytime they submit the Unique code - ONLY the code and promotion type changes BUT other details remain the same.
The script should fetch the ID of the entrant and the No. of entries made so far as is in the DB. e.g. ID - FREQUENCY
EXAMPLE "200 - 34 ENTRIES" - from the MySQL table so that an award can be presented to the MOST frequent entrant.
any help greatly appreciated