<?php

    $user = "root";
    $pass = "cxst2978";
    $host = "localhost";
    $dbname = "ca_wp";

    $link = mysql_connect($host, $user, $pass);
    $db = mysql_select_db($dbname);

    $id = $_GET["id"];

        $metas = array(
            'location', 'firstname', 'lastname', 'jobtitle', 'gradyear', 'alumni'
        );

        foreach ($metas as $i=>$meta_key) {

            $meta_fields[] = 'm' . $i . '.meta_value as ' . $meta_key;

            $meta_joins[] = ' left join wp_postmeta as m' . $i . ' on m' . $i . '.post_id= wp_posts.ID and m' . $i . '.meta_key="' . $meta_key . '"';
        }

        $request = "SELECT wp_posts.ID,  " .  join(',', $meta_fields) . " FROM wp_posts ";

        $request .=  join(' ', $meta_joins);

        $request .= " AND post_status='publish' AND post_type='people' AND wp_posts.ID = $id WHERE wp_posts.ID = $id LIMIT 1";

        //echo $request . "<hr />";

    $result = @mysql_query($request);

    while($row = mysql_fetch_assoc($result)) {

        $qry = "SELECT * FROM videos WHERE post_id = $id";
        $res = mysql_query($qry);
        while($vid = mysql_fetch_assoc($res)) {

            echo "<img src='".$vid["thumbnail"]."' style='width:90%' />";

        }

        echo "<span class='name'>" . $row["firstname"] . " " . ucfirst(substr($row["lastname"], 0, 1)) . ".</span>";
        echo "<span class='job'>" . $row["jobtitle"] . "</span>";
        echo "<span class='location'>" . $row["location"] . "</span>";

    }

 ?>