<?php
/*
Template Name: Bio
*/
?><?php


get_header(); ?>

<?
$username="brownima_stbio";
$password="VW;);";
$database="brownima_bio";
$server="localhost";


$conn = new mysqli($server, $username, $password, $database);
if ($conn->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " .     $mysqli->connect_error;
}

$sql = "SELECT * FROM people as P INNER JOIN thumbs T on P.ID=T.person INNER JOIN filepaths F WHERE F.ID=1 ORDER BY P.Lname, P.Fname ASC";
$result = $conn->query($sql);


 $row_cnt = $result->num_rows;
 printf("Result set has %d rows.n", $row_cnt);

$conn->close();


echo "Click on the picture, name, title or organization to read bio.";

for( $i = 0; $i < $row_cnt; $i++ ) {
$Fname=mysql_result($result,$i,"Fname");
$Lname=mysql_result($result,$i,"Lname");
$Suffix=mysql_result($result,$i,"Suffix");
$Position=mysql_result($result,$i,"Position");
$Organization=mysql_result($result,$i,"Organization");
$Thumb=mysql_result($result,$i,"Thumb");
$Root=mysql_result($result,$i,"Root");
$Uploads=mysql_result($result,$i,"Uploads");
$Pages=mysql_result($result,$i,"Pages");
echo "<div class="bioindex">";
echo "<div class="biohr"><hr></div>";
//  echo "<hr>";
//  echo "<a src="$Root$Uploads$Thumb"></a>First Name: $Fname $Lname<br />rn";

if ($Lname=="Brown"){
echo "<div class="indexpix fltlft"><a  title="$Fname $Lname"  href="http://www.storytellingonline.info/about/james-w-brown/" class="hiddenlink"><img class="alignnone size-full " title="$Fname $Lname" src="$Root$Uploads$Thumb" alt="" width="100" height="100" /></div>";
    if ($Suffix != "") {
    echo "<div class="indexname">$Fname $Lname, $Suffix</div></a>";
} else {
    echo "<div class="indexname">$Fname $Lname</div></a>";
}
echo "<div class="indextitle"><a  title="$Fname $Lname" href="http://www.storytellingonline.info/about/james-w-brown/" class="hiddenlink2">$Position</div>";
echo "<div class="indexcompany">$Organization</div></a>";
echo "<div class="clearfloat"></div>";
}
else {


    echo "<div class="indexpix fltlft"><a  title="$Fname $Lname" href="$Root$Pages$Fname-$Lname/" class="hiddenlink"><img class="alignnone size-full " title="$Fname $Lname" src="$Root$Uploads$Thumb" alt="" width="100" height="100" /></div>";
    if ($Suffix != "") {
        echo "<div class="indexname">$Fname $Lname, $Suffix</div></a>";
    } else {
        echo "<div class="indexname">$Fname $Lname</div></a>";
    }
    echo "<div class="indextitle"><a  title="$Fname $Lname" href="$Root$Pages$Fname-$Lname/" class="hiddenlink2">$Position</div>";
    echo "<div class="indexcompany">$Organization</div></a>";
    echo "<div class="clearfloat"></div>";

}


}


echo "</div>";

?>

<?php get_footer(); ?>