i am trying to make a table that shows 5 newest members from my community. what is wrong here?????
here is the live page of this code
http://www.hcrindienetwork.com/newmebers.php
<?php
// Connect to database
include_once "free/connect_to_mysql.php";
// Gather all the members for temporary display
$sql = mysql_query("SELECT id, username FROM members WHERE email_activated='1' ORDER BY id DESC LIMIT 5");
$MemberDisplayList = '<table border="0" align="center" cellpadding="6">
<tr> ';
while($row = mysql_fetch_array($sql)){
$id = $row["id"];
$username = $row["username"];
$username = substr($username, 0, 10);
/////// Mechanism to Display Pic. See if they have uploaded a pic or not //////////////////////////
$check_pic = "memberFiles/$id/pic1.jpg";
$default_pic = "memberFiles/0/pic1.jpg";
if (file_exists($check_pic)) {
$user_pic = "<img src=\"$check_pic\" width=\"80px\" border=\"0\" />"; // width attribute forces picture to be 80px wide and no more
} else {
$user_pic = "<img src=\"$default_pic\" width=\"80px\" border=\"0\" />"; // width attribute forces default picture to be 80px wide and no more
}
$MemberDisplayList .= '<td><div style=" height:80px; overflow:hidden;"><a href="http://www.hcrindienetwork.com/free/member_profile.php?id=' . $id . '">' . $user_pic . '</a></div><a href="http://www.hcrindienetwork.com/free/member_profile.php?id=' . $id . '"><div align="center" style=" width:80px; overflow:hidden;">' . $username . '</div></a></td>';
} // close while loop
$MemberDisplayList .= ' </tr>
</table> ';
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta name="Description" content="Page Description goes here" />
<meta name="Keywords" content="Page Keywords go here" />
<meta name="rating" content="General" />
<meta name="revisit-after" content="7 days" />
<meta name="ROBOTS" content="All" />
<title>your new cool site</title>
<link href="style/main.css" rel="stylesheet" type="text/css" />
<link rel="icon" href="http://www.yournewcoolsite.com/favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="http://www.yournewcoolsite.com/favicon.ico" type="image/x-icon" />
</head>
<body>
<table width="950" align="center">
<tr>
<td width="758" valign="top"><p align="center"><br />
NEWEST MEMBERS<br />
<?php print "$MemberDisplayList"; ?></p>
<table width="92%" align="center" cellpadding="6">
<tr>
<td width="100%"></td>
</tr>
</table>
</body>
</html>
