$query1 = "SELECT * FROM `users` ORDER BY reg_date";
$result=mysql_query($query1) or die(mysql_error());
$num1=mysql_numrows($result);
$i=0;
if ($i < $num1) {
$nickname = htmlentities(mysql_result($result,$i,"nickname"));
$dob = htmlentities(mysql_result($result,$i,"dob"));
$profileurl = htmlentities(mysql_result($result,$i,"profileurl"));
$gender = htmlentities(mysql_result($result,$i,"gender"));
$last_activity = htmlentities(mysql_result($result,$i,"last_activity"));
$year_now = date('Y');
$age = $year_now - $dob ;
echo ('
| Newest Members |
 |
NickName: '.$nickname.'
Age: '.$age.'
Gender: '.$gender.'
Last Active: '.$last_activity.'
Profile: view |
|
');
$i++;
}