title: send reminder emails with php and mysql WITHOUT cron-job?
body: <p>I just made a php script that will send email reminders to admins of a website 2 days before an appointment begins. I was going to automate the script to run through a cron job, only to realise who I am hosting with (crazy domains) does NOT appear to have Cron Jobs</p>
  
  <p>Is there ANY way of doing this without cron-jobs? I do not mind going to a different service provider if that is the case; I have done quite a bit of searching around, and my understanding so far is that I need Cron Jobs for these types of things? </p>
  
  <p>Here is the script I did so far:</p>
  
  <pre><code>&lt;?php include "../connect-to-database.php";  ?&gt;
  
  &lt;?php   
      $date = date("Y-m-d");
      $mod_date = strtotime($date."+ 2days");
      $newDate = date("m/d/Y",$mod_date);
  
      $sqlCommand = "SELECT * FROM eventcalender WHERE eventDate='$newDate'" ;
      $query = mysql_query($sqlCommand) or die(mysql_error());
      $count = mysql_num_rows($query);
  
  if ($count &gt;= 1){
          while($row = mysql_fetch_array($query)){
              $ID = $row["ID"];
      $schedule_title = $row["Title"];
      $schedule_description = $row["Detail"];
      $importance_level = $row["importance_level"];
      $meeting_datetime = $row["eventDate"];
      $contacts_involved = $row["contacts_involved"];
      $meeting_occurred = $row["meeting_occurred"];
  
      $mid = mysql_insert_id();
      $search_output .= "&lt;ul&gt;
                  &lt;li&gt;
                      &lt;h4&gt;".$schedule_title."&lt;/h4&gt;
                      &lt;p&gt;&lt;b&gt;Time: ".$meeting_datetime."&lt;/b&gt;&lt;/p&gt;
                      &lt;p&gt;People/Persons involved: ".$contacts_involved."&lt;/p&gt;
                      &lt;p&gt;Meeting Occurred?: ".$meeting_occurred."&lt;/p&gt;
                      &lt;a href='uniqueMeeting.php?ID=".$ID."'&gt;View more details of this meeting&lt;/a&gt;
                      &lt;p&gt;&lt;a href='editschedulePage.php?mid=$ID'&gt;Edit This Meeting&lt;/a&gt;&lt;/p&gt;
                      &lt;p&gt;&lt;a href='scheduleList.php?deleteid=$ID'&gt;Delete this meeting&lt;/a&gt;&lt;/p&gt;
                  &lt;/li&gt;&lt;br/&gt;                  
              &lt;/ul&gt;";
  
              $sendMail = true;
          }
  
  }
  
  if($sendMail){  
      $admin = "SELECT * FROM admin" ;
      $queryAdmin = mysql_query($admin) or die(mysql_error());
      $adminCount = mysql_num_rows($queryAdmin);
      $recipients = array();
          if ($count &gt;= 1){
              while($row = mysql_fetch_array($queryAdmin)){
  
              $subject ='A-CRM; UpComing Activities';
              $msg = $search_output; 
              $to = $row['email_address'];
              mail($to, $subject, $msg);
              }   
          }
  }
  
  ?&gt;
  </code></pre>
  
  <p>Yes I do realise I am an absolute horrible person for NOT using mysqli, and I will start to as soon as I finish this website</p>