Page 1 of 1

querying multiple tables?

Posted: Tue Nov 04, 2008 10:45 pm
by 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.
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
}
Like for viewing topic i given link. How to give link to author how can i fetch his profile from userlist.

Re: querying multiple tables?

Posted: Wed Nov 05, 2008 3:25 am
by aceconcepts
How about using a JOIN?