Mine

				$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 ('
					      <tr>
							<td colspan="3" background="img/index_cap_bg1.jpg"><strong>&nbsp;Newest Members </strong></td>
						  </tr>
						  <tr>
							<td width="14%" align="center" valign="middle">&nbsp;<img src="'.$avatar.'" width="85" height="85"></td>
							<td width="46%" align="left" valign="top"><strong>NickName:</strong> '.$nickname.'<br>
							  <strong>Age: </strong>'.$age.'<br>
							  <strong>Gender:</strong> '.$gender.'<br>
							  <strong>Last Active: </strong>'.$last_activity.' <br>
							  <strong>Profile:</strong> <a href="http://thesocialplanet.com/'.$profileurl.'">view</a> </td>
							<td width="40%" align="left" valign="top"">&nbsp;</td>
						  </tr>');				  				
				$i++; 
				}