querying multiple tables?

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
sunil16
Forum Newbie
Posts: 1
Joined: Tue Nov 04, 2008 10:39 pm

querying multiple tables?

Post 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.
User avatar
aceconcepts
DevNet Resident
Posts: 1424
Joined: Mon Feb 06, 2006 11:26 am
Location: London

Re: querying multiple tables?

Post by aceconcepts »

How about using a JOIN?
Post Reply