'; } // return array of supporters (Supporter,Link), selected randomly function randomSupporters($limit = false) { $sql = "Select * from ActiveSupporters"; if ($limit) $sql .= " limit $num"; $result = mysql_query($sql); $res = array(); if ($result) { while ($row = mysql_fetch_assoc($result)) { $link = trim($row['Website'] != ''?$row['Website']: ($row['FacebookFollowing']?$row['Facebook']: ($row['TwitterFollowing']?$row['Twitter']: ($row['GooglePlusFollowing']?$row['GooglePlus']: ($row['OtherSocialMedia']?$row['OtherSocialMedia']:false) ) ) ) ); if ($link && strncasecmp($link,'http:',5)) $link = 'http://'.$link; $res[] = array('Supporter'=>$row['GroupName'],'Link'=>$link); } } return $res; } // return Weekly Audience Average function weeklyAudienceAverage() { $sql = "select * from BrochureGeneral where Dname='WeeklyAudienceAverage'"; $result = mysql_query($sql); $row = mysql_fetch_array($result); if ($row) return $row['DValue']; } ?>