These are rides members have currently indicated they are doing on the shared google docs spreadsheet:
Season 2019/2020
[insert_php]
$csv_rides = file_get_contents(‘https://docs.google.com/spreadsheet/pub?key=0AqbAsrKqqIRadFNTWHdwN24wRXdrMm9neE5ucGhqTmc&single=true&gid=0&output=csv’);
$ride_rows = str_getcsv($csv_rides, “\n”);
for ($row = 0; $row < count($ride_rows); $row++)
{
$elements = str_getcsv($ride_rows[$row]);
if (strlen($elements[1]) > 1)
{
if (!$header)
{
$header = $elements;
} else {
$next_elements = str_getcsv($ride_rows[$row+1]);
//date column
echo ‘‘ . $elements[1] . ‘ – ‘;
//ride and url column and 2 rows
if (strpos($next_elements[2], “http”) === 0)
echo ‘‘ . $elements[2] . ‘: ‘;
else
echo $elements[2] . ‘: ‘;
$prefix = ”;
for ($i = 3; $i < count($header); $i++)
// member riding yes or no
{
if ($elements[$i] && strtoupper($elements[$i]) != 'NO') {
echo $prefix . $header[$i] . ' (' . strtolower($elements[$i]) . ')';
$prefix = ', ';
}
}
echo '.
‘;
}
}
}
[/insert_php]
