HTML;
$dbh = new PDO('mysql:host=localhost;dbname=mdcc', 'mdcc', 'Mdcc.');
echo <<
| ID |
Case ID |
Last name |
First name |
Middle name |
Race |
Sex |
HTML;
echo "";
$st = $dbh->prepare("SELECT * FROM akas WHERE case_id = '{$_GET['case_id']}'");
if ( $st->execute() ) {
$alt = 'alt';
while ( $row = $st->fetch(PDO::FETCH_ASSOC) ) {
$alt = $alt ? '' : 'alt';
echo " \n";
foreach ( $row as $field ) {
echo " | $field | \n";
}
echo "
\n";
}
}
echo <<
HTML;
?>