<?php

$username="database";

$password="username";

$database="password";



mysql_connect(localhost,$username,$password);



@mysql_select_db($database) or die( "Unable to select database");



$sql = "SELECT a.*\n"

    ." FROM checkout a\n"

    . " INNER JOIN (\n"

    . " SELECT fullname, max(dateandtime) as dateandtime\n"

    . " FROM checkout\n"

    . " GROUP BY fullname\n"

    . " ) b \n"

    . " ON a.fullname=b.fullname\n"

    . " AND a.dateandtime=b.dateandtime\n"

    . " ORDER by a.fullname\n"

    . " Limit 0, 30 ";



$result = mysql_query($sql);


?>

<table border="0" cellspacing="5" cellpadding="5">

<tr>

<td><b><font face="Arial, Helvetica, sans-serif">Name</font></td></b>

<td><b><font face="Arial, Helvetica, sans-serif">Status</font></td></b>



</tr>



<?php

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {

?>

<tr>

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

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

</tr>

<?php

}

?>

</table>