Click here to select State
  Alaska
  Alabama
  Arkansas
  Arizona
  California
  Colorado
  Connecticut
  District of Columbia
  Delaware
  Florida
  Georgia
  Hawaii
  Iowa
  Idaho
  Illinois
  Indiana
  Kansas
  Kentucky
  Louisiana
  Massachusetts
  Maryland
  Maine
  Michigan
  Minnesota
  Missouri
  Mississippi
  Montana
  North Carolina
  North Dakota
  Nebraska
  New Hampshire
  New Jersey
  New Mexico
  Nevada
  New York
  Ohio
  Oklahoma
  Oregon
  Pennsylvania
  Rhode Island
  South Carolina
  South Dakota
  Tennessee
  Texas
  Utah
  Virginia
  Vermont
  Washington
  Wisconsin
  West Virginia
  Wyoming

"; include("img/util.php");$sql = new MySQL_class;$sql->Create("localDatabase"); $list .="

"; $query=str_replace(' ','-',$query);$qSurch=str_replace(' ','',$qLower);if($qSurch=="nearme" || $qSurch=="nearby"){$qSurch="";} $selList="SELECT UniqueID, Member, Left(Party,1) HomeState, District, MeetingType, Ldate, StartTime, EndTime, TimeZone,Location, Address, City, State, Zip, latitude, longitude, Notes, Source FROM AllMeeting WHERE state = 'IN' ORDER by EventDate LIMIT 50"; //round(SQRT(POW(69.1 * (latitude - $ylat), 2) + POW(69.1 * ($ylon - longitude) * COS(latitude / 57.3), 2)),1) AS distance $sql->Query($selList); for ($i=0;$i<$sql->rows;$i++){ $sql->Fetch($i); $UniqueID = $sql->data[0]; $Member = $sql->data[1]; $Party = $sql->data[2]; $HomeState = $sql->data[3]; $District = $sql->data[4]; $Type = $sql->data[5]; $EventDate = $sql->data[6]; $StartTime = $sql->data[7]; $EndTime = $sql->data[8]; $TimeZone = $sql->data[9]; $name = $sql->data[10]; $address = $sql->data[11]; $address=strtolower($address);$address=ucwords($address); $city = $sql->data[12]; $city1=strtolower($city);$city1=ucwords($city1); $state = $sql->data[13]; $state1=strtolower($state); $zip = $sql->data[14]; $webLink=" "; if($address <>''){$addrLink="";}else{$addrLink=" ";} if($phone <>''){$phoneLink="";}else{$phoneLink=" ";} if($website <>''){$webLink="";} $facebook =""; $twitter =""; $allIcon="$addrLink $facebook $twitter"; if($sql2->rows==0 && $tagkey <> ""){ $selDeal="SELECT id, title, link, name, tagkey FROM ls_deals Where title<>'' and tagkey = '$tagkey'";$sql2->Query($selDeal); } if($sql2->rows>0){ for ($j=0;$j<$sql2->rows;$j++){$sql2->Fetch($j); $id = $sql2->data[0]; $titleD = $sql2->data[1]; $linkD = $sql2->data[2]; $nameD = $sql2->data[3]; $mydeal = "

"; }} if ($EndTime<>""){$etime ="
From: $StartTime - To: $EndTime";} else {$etime =" From: $StartTime";} $list .= "

$name $EventDate Town Hall Meeting

with $Member ($Party)
On $EventDate $etime

$address
$city, $state - $zip

$allIcon

"; if($i==2 || $i==7 || $i==12 || $i==17){$list .="

$ad

"; } }$sql->Close(); $list .="

"; ?>