Jump to content

I-T

Members
  • Content count

    5
  • Joined

  • Last visited

Community Reputation

0 Neutral

About I-T

  • Rank
    Newbie
  • Birthday 07/24/1991

Profile Information

  • Location
    Australia
  1. So I would be adding that select statement to my phpscript? if so Why do I need to loop it if its only going to retrieve the emails who are only set to active_flag =1
  2. Come to think about it I probably have to create multiple cron tabs to flow with the event scheduler
  3. I really appreaciate your responses but bare with me plz.This is the full scale of what I'm trying to do. Firstly I want to run an event scheduler in mysql so that on 9:00AM the active flag field for the 1st 200 emails would be set to 1, then at 10:30AM have another event to set them back to 0, and at that very exact time have another event for the whole new 200 batches set to 1. then so on and so fourth till like 5.00PM I figured out the sql query to do this. Now that in mind I understand that I could simply create a cron job by going into c-panel and accesing the cron icon. It gives me the option to set a crontab which is by picking the times and dates, and also you would see the command box which as you mentiond would require for me to enter something like this "php -f /home/public_html/cron.php" so that it would run my php script that I created. Ok now ofcourse I havent created such a script. Could you give me some sort of a script example where it would grab the emails from my database within a certain table which hold all the emails and ultimately who are only set to 1 in active_flag field. Just to mention I would set the event scheduler and the cron tab to similar times so that it will flow nicely.
  4. Ok so in c-panel I would click the cron icon. I belive it gives you a step by step process to make a cron-tab which I belive is the php script it will create? Once thats done how do I make it grab the 200 emails from my database that are set to active_flag 1 for it to send?
  5. Ok this is my issueCurrently I have a specific table in my database that holds all the email addresses that i send an email to.The 200 bulk emails gets sent by going into the CMS(content management system).In the database their is a field called active_field and by default all set to 0. I only turn them to 1 when the 200 emails are ready to be sent. This method takes too long seeing that I send 200 bulks of email about an hour or abit longer and I manually have to re run the query to set the ones I already sent back to active_flag 0 and grab a whole new 200 and set them to active_flag 1. I did research on cron and I belive you can schedule it to send the bulk email every hour but I dont know how to use it or where to start. or maybe use some sort of a trigger method on mysql phpadmin to set the active_flags to 1 when the 1 hour time is up??Any ideas or solutions would be highly appreciated. thanks
×