sort2-Java2yaHOO

[insert_php]
$servername = ‘localhost’;
$username = ‘i3141100_wp2’;
$password = ‘I.YLB7jy7H9JwGZ199H12’;
//$dbname = localhost;
$dbname = ‘i3141100_wp2’;
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error)
{
die(“Connection failed: ” . $conn->connect_error);
}
else
{
// Get the result…
global $wpdb;
$resultsA = $wpdb->get_results (“SELECT fname, lname, lastyr,currstat
FROM cbraepeople “, ARRAY_A);

}
$i=0;
foreach ($resultsA as $row)
{
echo “

“;
echo “

“;

echo “

“;

echo “

“;

echo “

“;
echo “

“;
$i++;
}

[/insert_php]

First Name	Last Name	Last Year Attended	Current Status For Event
“; echo “$row[fname]”; echo “	“; echo “$row[lname]”; echo “	“; echo “$row[lastyr]”; echo “	“; echo “$row[currstat]”; echo “