Untitled

print('N. of records: '.$result->num_rows.'<br />');
print('<table>');
while ($row = $result->fetch_object()){
    print('<tr><td>'.$row['last'].'</td><td>'.$row['first'].'</td></tr>');
}
print('</table>');

<html>
<body>

<?php

$dbhost = 'localhost:3306';
$username = "root";
$password = "";
$database = "newworld";

$conn =mysqli_connect($dbhost, $username, $password, $database);

if(! $conn ) {
    die('Could not connect: ' . mysqli_error());
} else {
    #db connected
}

/**/
$sql = 'SELECT first, last FROM photos';
$result = mysqli_query($conn, $sql);

/**/

?>

    <table border="1" cellspacing="2" cellpadding="2">
        <tr>
            <td><font face="Arial, Helvetica, sans-serif"><u>first</u></font></td>
            <td><font face="Arial, Helvetica, sans-serif"><u>last</u></font></td>
        </tr>

        <?php

        if (mysqli_num_rows($result) > 0) {

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

               ?>

               <tr>
                <td><font face="Arial, Helvetica, sans-serif"><?php echo $row["first"]; ?></font></td>
                <td><font face="Arial, Helvetica, sans-serif"><?php echo $row["first"]; ?></td>
               </tr>

               <?php
            }

        } else {
            echo "0 results";
        }
        ?>
    </table>
</body>
</html>