How to put MySQL in Tables with Rows

[A1SURF.us]

I'm trying to pull user referral data from my database. This is what I have so far.

 

<table cellpadding="0" cellspacing="0" style="border:1px #000000 solid;" width="68%">
<tr>
<td bgcolor="#eeeeee" style="padding:2px;border-right:1px #000 solid;border-bottom:1px #000 solid;"><font size="2" face="verdana"><b>
User
</b></font></td>
<td bgcolor="#eeeeee" style="padding:2px;border-right:1px #000 solid;border-bottom:1px #000 solid;"><font size="2" face="verdana"><b>
Email
</b></font></td>
<td bgcolor="#eeeeee" style="padding:2px;border-right:1px #000 solid;border-bottom:1px #000 solid;"><font size="2" face="verdana"><b>
Date
</b></font></td>
<td bgcolor="#eeeeee" style="padding:2px;border-bottom:1px #000 solid;"><font size="2" face="verdana"><b>
Visits
</b></font></td>
</tr>


<?

$lole=$_COOKIE["usNick"];

$tabla = mysql_query("SELECT * FROM tb_users where username='$lole' ORDER BY id ASC"); 

while ($row = mysql_fetch_array($tabla)) { 




echo "<tr><td><font size=\"2\" face=\"verdana\">";

echo $row["username"];

echo "</font></td><td><font size=\"2\" face=\"verdana\">";

echo $row["email"];

echo "</font></td><td><font size=\"2\" face=\"verdana\">";

echo $row["joindate"];

echo "</font></td><td><font size=\"2\" face=\"verdana\">";

echo $row["visits"];

echo "</font></td></tr>";

}

echo "</table>";

?>




<script type="text/javascript">
initSortTable('myTable',Array('S','N','S','N','S'));
</script>

 

 

I just found out my user ID is missing from database..

[A1SURF.us]

This is what I got to work..

 

How do I get the join date to show up properly, it's just showing numbers?

 

I replaced it with this line and the date works.

 

echo date("d M Y h:i A",$row["joindate"]);

 

Anyone want to clean it up? Or point out some other weakness..

 

 

<?php include('header.php');?>
   <div id="content_wrapper" style="padding-left:5%;padding-right:5%;">


<div width="80%" align="center">

<?

if(!isset($_COOKIE["usNick"]) && !isset($_COOKIE["usPass"]))
{
exit();
}

include('menum.php'); ?>

<table cellpadding="0" cellspacing="0" style="border:1px #000000 solid;" width="68%">
<tr>
<td bgcolor="#eeeeee" style="padding:2px;border-right:1px #000 solid;border-bottom:1px #000 solid;"><font size="2" face="verdana"><b>
User
</b></font></td>
<td bgcolor="#eeeeee" style="padding:2px;border-right:1px #000 solid;border-bottom:1px #000 solid;"><font size="2" face="verdana"><b>
Email
</b></font></td>
<td bgcolor="#eeeeee" style="padding:2px;border-right:1px #000 solid;border-bottom:1px #000 solid;"><font size="2" face="verdana"><b>
Date
</b></font></td>
<td bgcolor="#eeeeee" style="padding:2px;border-bottom:1px #000 solid;"><font size="2" face="verdana"><b>
Visits
</b></font></td>
</tr>


<?

$lole=$_COOKIE["usNick"];

$tabla = mysql_query("SELECT * FROM tb_users where referer='$lole' ORDER BY id ASC");

while ($row = mysql_fetch_array($tabla)) { 


echo "<tr><td><font size=\"2\" face=\"verdana\">";

echo $row["username"];

echo "</font></td><td><font size=\"2\" face=\"verdana\">";

echo $row["email"];

echo "</font></td><td><font size=\"2\" face=\"verdana\">";

echo $row["joindate"];

echo "</font></td><td><font size=\"2\" face=\"verdana\">";

echo $row["visits"];

echo "</font></td></tr>";

}

echo "</table>";

?>




<script type="text/javascript">
initSortTable('myTable',Array('S','N','S','N','S'));
</script><br>
</div>
</div>
<?php include('footer.php');?>