";
}
//$query1= "select fb2.name, fb2.value,fb6.value,fb11.value,fb17.value,fb34.value,fb53.value,fb87.value,fb129.value,tblDataCodes.fips,tblDataCodes.iso,fb0.value,fbURLs.value,$dataTable.value from fb2,fb6,fb11,fb17,fb34,fb53,fb87,fb129,tblDataCodes,fb0,fbURLs,$dataTable where (fb2.name=fb6.name and fb2.name=fb11.name and fb2.name=fb17.name and fb2.name=fb34.name and fb2.name=fb53.name and fb2.name=fb87.name and fb2.name=fb129.name and fb2.name=tblDataCodes.name and fb2.name=fb0.name and fb2.name=fbURLs.name and fb2.name=$dataTable.name and (fb0.value LIKE \"%independent%\") and ".$theCondition.") order by fb2.name";
$query1="SELECT * FROM mayors";
$result=mysql_query($query1);
$selections="";
$position=1;
while (($line = mysql_fetch_array($result)))
{
$name=$line[2];
$selections=$selections."";
$position=$position+1;
}
$number_of_results=mysql_num_rows($result);
if($slide>$number_of_results){$slide=1;}
$countdown=$number_of_results-$slide+1;
//mysql_data_seek($result, $slide-1);
mysql_data_seek($result, $number_of_results-$slide);
$line=mysql_fetch_array($result);
$city=$line[0];
$country=$line[1];
$name=$line[2];
$dob=$line[3];
$alma_mater=$line[4];
$profession=$line[5];
$degrees=$line[6];
$known_for=$line[7];
$assumed_office=$line[8];
$image=$line[9];
$city_population=$line[10];
$twitter_handle=$line[11];
$twitter_followers=$line[12];
$percentage_of_population=$line[13];
$today = date('YYYY-MM-DD');
$age = floor((time() - strtotime($dob)) / 31556926);
$titleName=" - ".$name;
if($countdown==10){$titleName="";}
$fileData="
![](\"/images/people/".$image."\")
City: ".$city.", ".$country."";
$fileData=$fileData."Population: ".number_format($city_population)."";
$fileData=$fileData."Age: ".$age."";
$fileData=$fileData."Alma mater: ".$alma_mater."";
$fileData=$fileData."Degrees: ".$degrees."";
$fileData=$fileData."Profession: ".$profession."";
$fileData=$fileData."Twitter Followers: ".number_format($twitter_followers)." ".$twitter_handle." (".$percentage_of_population."% of population)