=curdate() AND bd45_events.calendar_id = 1 ORDER BY bd45_dates.event_date ASC "; $query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1); $Recordset1 = mysql_query($query_limit_Recordset1, $ststeph) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1); if (isset($_GET['totalRows_Recordset1'])) { $totalRows_Recordset1 = $_GET['totalRows_Recordset1']; } else { $all_Recordset1 = mysql_query($query_Recordset1); $totalRows_Recordset1 = mysql_num_rows($all_Recordset1); } $totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1; mysql_select_db($database_ststephen, $ststephen); $query_Recordset2 = "SELECT bd45_events.event_id, bd45_events.event_title, bd45_events.event_description, bd45_dates.event_date, bd45_dates.event_time_start, bd45_dates.event_time_end, bd45_events.event_location1, bd45_events.event_attachment1, bd45_events.contact_name, bd45_events.contact_email, bd45_events.event_custom1 FROM (bd45_events LEFT JOIN bd45_dates ON bd45_dates.event_id=bd45_events.event_id) WHERE bd45_dates.event_date>=curdate() AND bd45_events.event_custom1>0000-00-00 ORDER BY bd45_dates.event_date ASC, bd45_dates.event_time_start ASC "; $Recordset2 = mysql_query($query_Recordset2, $ststephen) or die(mysql_error()); $row_Recordset2 = mysql_fetch_assoc($Recordset2); $totalRows_Recordset2 = mysql_num_rows($Recordset2); // Initialize the Alternate Color counter $ac_sw1 = 0; ?>
|
|
|
||||||||||||||||