querying multiple tables?
Posted: Tue Nov 04, 2008 10:45 pm
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.
I am Two tables One is Userlist and other is Forum topic
Below is my code
Like for viewing topic i given link. How to give link to author how can i fetch his profile from userlist.
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.
I am Two tables One is Userlist and other is Forum topic
Below is my code
Code: Select all
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
}