Giving link for Author Name in Forum?

[SUNIL16]

Hi Friends,

 

I Created a Forum, Which is working nice but i am not getting how can i give link to the author of the post. How to retrieve his profile only, If i give link. Please give some suggestions.

 

Below is my code 

 

echo"<table width='90%' border='0' align='center' cellpadding='3' cellspacing='1' bgcolor='#CCCCCC'>
<tr>
<td width='6%' align='center' bgcolor='#E6E6E6'><strong>#</strong></td>
<td width='53%' align='center' bgcolor='#E6E6E6'><strong>Topic</strong></td>
<td width='15%' align='center' bgcolor='#E6E6E6'><strong>Views</strong></td>
<td width='13%' align='center' bgcolor='#E6E6E6'><strong>Replies</strong></td>
<td width='13%' align='center' bgcolor='#E6E6E6'><strong>Author</strong></td>
</tr>";


$query=" SELECT * FROM $tbl_name   limit $eu, $limit ";
$result=mysql_query($query);
echo mysql_error();


while($row=mysql_fetch_array($result)){ // Start looping table row

echo "<tr>";
echo "<td bgcolor='#FFFFFF'>";
echo $row['id'];
echo "</td>";
echo "<td bgcolor='#FFFFFF'>";
echo "<a href='viewtopic_ct.php?id=".$row['id']."'>".$row['topic']."</a><BR></td>";
echo "<td align='center' bgcolor='#FFFFFF'>";
echo $row['view'];
echo "</td>";
echo "<td align='center' bgcolor='#FFFFFF'>";
echo $row['reply'];
echo "</td>";
echo "<td align='center' bgcolor='#FFFFFF'>";
echo $row['name'];
echo "<br/>";
echo $row['datetime'];
echo "</td>";
echo "</tr>";

// Exit looping and close connection
}

 

Like for viewing topic i given link. How to give link to author how can i fetch his profile from userlist.

[Adam]

You'll need to look into querying multiple tables:

 

http://www.google.co.uk/search?q=mysql+query+multiple+tables