Query to Get the Latest Events from a Specific Calendar

[LancerForums]

Hi,

Does anyone know what the query would be to select a list of events from a particular calendar?

Thanks,

Mark

[mcahill]

Not pretty code, not optimized code. But it does pull events from only the public folder for use on my homepage. No warranty expressed or implied...use at own risk...your mileage may vary.

PHP Code:

<?
            
            
            $fudgedate = strtotime("yesterday");
              //$eventdate = mktime($yesterday);
            
            

              $events = mysql_query("SELECT * FROM event where dateline_from = '$fudgedate' or dateline_from > '$fudgedate' and recurring !=3 and calendarid = 1 order by dateline_from asc limit 8") or die("oops3");
            
            $eventrow = mysql_fetch_array($events);
                    
            while ( $rowevents = mysql_fetch_array($events) ) { 
            
                    
            echo "<a href='http://sitename.com/forum/calendar.php?do=getinfo&e=" . $rowevents['eventid'] ."'>";
            echo $rowevents['title'];
            echo "</a> ";
            if ($rowevents['recurring'] == 0 and $rowevents['dateline_to'] == 0) {
            $fixdate = ($rowevents['dateline_from'] + 86400);
            } 
            else {
            $fixdate = $rowevents['dateline_from'] ;
            }
            echo date("D M j",$fixdate);
            echo "<br>";
            
                
    }

        
          ?>

It has a bit of trouble with some of the ranged date events, but it's good enough for what I use it for. If you improve it, post it back up here...

Cheers,

Mark