I'm not sure if this is possible or not, but let me explain what i'm trying to implement on my website "Written in PHP with MySQL". Ok! i'm designing a lead generation/mailing list business website, and need to know if it's possible to say, select data from the table that i configured the form to store the prospects info into, and randomly add leads to all my users based on the amount of lead they ordered. I have made the option of ordering lead packages of 10, 20, 30, 40. So would it be possible to make a php script to randomly take leads from that table and add them to the users accounts until their order is filled with the set amount of leads?.
Hi! thank you! for the quick replys. Ok! let me explain in detail what i want this application to do!.
1. Ok! i have my form data stored into a MySQL table, now i would like to beable to automatically (Hopefully Not Manually) select a random lead from that table, move that data into a clients lead data table - and then delete that lead from the form data table so i won't have a double copied lead.
2. Ok! next thing, i want the database to be able to delete leads that are 30 days old in the clients database automatically.