All pastes #274164 Raw Edit

Something

public text v1 · immutable
·published 2006-12-10 13:54 UTC
rendered paste body
function monthEvents() {
	
   $sql = "SELECT * FROM calendar WHERE eventType = 'Months'";
   $results = mysql_query($sql) or die(mysql_error());
	
   $start = GregorianToJD($this->month, 1, $this->year);
			
   while( $row = mysql_fetch_assoc($results) ) {
		
		
      echo "<pre>";
      var_dump($row);
      echo "</pre>";
			
      echo "<pre>";
      var_dump($start);
      echo "</pre>";
		

      if( $start <= intval($row['startDate']) ) {
         
         echo $startMonth;
	 
         if( $this->month == $startMonth) {
	    echo "hi";
	    die();
	 }
      }
   }
   die();
}


-------  OUTPUT -----


array(14) {
  ["Key_ID"]=>
  string(1) "4"
  ["startDate"]=>
  string(7) "2454079"
  ["endDate"]=>
  string(7) "2454079"
  ["startTime"]=>
  string(8) "08:00:00"
  ["endTime"]=>
  string(8) "22:00:00"
  ["eventType"]=>
  string(6) "Months"
  ["repeat"]=>
  string(1) "3"
  ["title"]=>
  string(11) "Send Sample"
  ["location"]=>
  string(22) "Second Sample Location"
  ["content"]=>
  string(13) "Second Sample"
  ["days"]=>
  string(1) "1"
  ["month"]=>
  string(1) "0"
  ["weekDay"]=>
  string(1) "0"
  ["weekNumber"]=>
  string(1) "0"
}

int(2454071)