Hi, I have the following: -2000 UNIQUE coupon codes for a specific service in a text file (one on each line) the formats of: AJZK-FZFZ-Z3NZ-ZR3L AJZK-FZFZ-Z3NZ-ZR3L-Y AJZK-FZFZ-Z3NZ-ZR3L-ZZ I need the following: -A programmer with flawless communication, and MSN messenger. -These coupons populated into a MySQL database, and the script/command to do that so I can do it myself in the future. -The coupon to show up in a members area of my site. -Each coupon should be UNIQUE when shown, and show again to the same person only, and exclusively... for example: Bob logs into his account, he is greeted by "Hi Bob, your coupon code is: AJZK-FZFZ-Z3NZ-ZR3L". The next time Bob logs in, he should see the same coupon code, and nobody else should be shown it, ever! Jeff logs into his account, he is greeted by "Hi Jeff, your coupon code is: AJZK-FZFZ-Z3NZ-ZR3L-Y". The next time Jeff logs in, he should see the same coupon code, and nobody else should be shown it, ever! etc... so basically a unique coupon gets pulled from the DB, shown to the user each time he logs in, and never gets shown to another user. This will be integrated to webpage. Maybe with a simple php include, but I'm not a programmer. Anyway, please PM me with your quote, etc. Payment will be made in 4 payments for every 25% progress. Please PM me, thanks!
Depending on what type of login-platform you're using, what type of admin-panel etc., this shouldn't be to hard to implement - just make a database-table containing a unique identifier column that can be linked to the users logging in, and a field for the code itself - then you check when the user logs in if there is a row in the database with that user's ID- if not, add that user's ID to the first row in the database which has an empty ID-field - and so on and so on - until you reach 2000 user IDs, then just display a message saying "no more coupons available" or something similar. To add coupon codes you could either generate them automatically using rand() functions, or make a form where you add them one by one or by uploading a file to the server and parsing that.