Search National Registry – Pullman Porter

Please enter last name

---

Last Name

[insert_php]
global $wpdb;

if(isset($_POST[‘search’]))
{
if (isset($_POST[‘query’]) && !empty($_POST[‘query’])) {
$LASTNAME = $_POST[‘query’];
$query = ‘SELECT FIRSTNAME,LASTNAME,RAILROAD,POSITION,YEARS_OF_SERVICE FROM wp_registrants WHERE LASTNAME LIKE ‘ . “‘%” .$LASTNAME. “%'” ;

$results = $wpdb->get_results($query);

echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;

foreach ($results as $row)
{

echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;

echo “

“;

}
echo “

First Name	Last Name	Rail Road	Position	Years of Service
” . $row->FIRSTNAME . “	” . $row->LASTNAME . “	” . $row->RAILROAD . “	” . $row->POSITION . “	” . $row->YEARS_OF_SERVICE . “

“;

}
else {

echo “Sorry not found.”;
}
}

[/insert_php]