Skip to content

Instantly share code, notes, and snippets.

@rorvetti
rorvetti / gist:7f11c6b4cfaee9b196cd743dc31931ee
Created August 29, 2016 21:30
Current Events - Full List
// Get upcoming events
$today = date("Y-m-d");
$query1 = "SELECT * FROM events where start_date >= '$today' and private_event <> 'Y' order by start_date";
$result1 = pg_query($query1); // Run query
/* Access the data in "event_desc," and organize it as an array by ID number */
// Get regular event descriptions
if( $desc_columns == '' )
$desc_columns = '*';
if( $desc_where == '' )
@rorvetti
rorvetti / events.php
Last active August 29, 2016 21:25
Upcoming Events - Site Homepage
// Get upcoming events, intended for site homepage
$today = date("Y-m-d");
$query1 = "SELECT * FROM events where start_date >= '$today' order by start_date limit 3";
$result1 = pg_query($query1); // Run query
$events = '';
if($result1)
{
$rows = pg_num_rows($result1);