Back

Names for New York Records from Database

This shows the names for all the records from New York.

Pulled Records
ID	NAME
	Garrett Mag
	Bank of New York
	Weitzman Construction
	Rubin Sands
	Rags to Riches Inc.
	Mcadams Investments
	HallMark Rentals
	Scheiby Loans
	Coburn Homes

CODE FOLLOWS


<?php
error_reporting(E_ALL);

include('includes/header.php');

$con = '';
?>
<h1>Names for New York Records from Database</h1>
<h2>This shows the names for all the records from New York.</h2>
<table class="full">
    <tr>
        <th colspan="10" class="header1">Pulled Records</th>
    </tr>
    <tr class="header2">
        <th>ID</th>
        <th>NAME</th>
    </tr>
    <?php
include('open-db.php');
$query = "SELECT name FROM clients WHERE state = 'NY' ";
$result = mysqli_query($con, $query) or die("Could not get data: $query " . mysqli_error());

    $i = 0;
    while ($row = mysqli_fetch_array($result))
    {
    $id = $row['id'];
    $name = $row['name'];
    ?>
    <tr class="row<?php echo($i++ & 1); ?>">
        <td>
            <?php echo($id); ?>
        </td>
        <td>
            <?php echo($name); ?>
        </td>
    </tr>
<?php
}
include('close-db.php');
    ?>

</table>
<hr>

<?php
include('includes/footer.php');
?>

?>
}

Back

?> }