Displaying your recently joined members

Tweet

<?php
require_once ('connect.php');
$myquery = mysql_query("SELECT name, location FROM members
                        ORDER BY join_date DESC LIMIT 5");
while ($row = mysql_fetch_array($myquery))
{
echo "<li>" . $row['name'] . " from " . $row['location'] . "</li>";
}
?>

From : http://www.shaunellerton.co.uk/2012/01/23/php-snippet-displaying-recently-joined-members-from-your-mysql-database/

Comments (Your Comments)