Jump to content


Photo

Displaying data from two tables


  • Please log in to reply
1 reply to this topic

#1 slack

slack
  • Members
  • PipPip
  • Member
  • 10 posts

Posted 03 April 2006 - 07:20 PM

Hi all,

I have problem with displaying data from two tables. There are two tables as follows:

TABLE1
ID-------NAME
1--------John
2--------Mark
3--------Kelly

TABLE2
ID-------REF------REFNAME
1--------A1--------Mark
2--------A2--------Kelly
3--------A3--------Kelly
4--------A4--------Mark

As you can see REFNAME in TABLE2 referances NAME in TABLE1.

In php I want the information to be displayed like this:

John
NONE

Mark
A1
A4

Kelly
A2
A3

I am not sure if this can be done by a SQL JOIN or some sort of loop.

Can someone help me display the information I want.

Thanks
Slack

#2 slack

slack
  • Members
  • PipPip
  • Member
  • 10 posts

Posted 04 April 2006 - 12:34 AM

Problem solved.

Had to use 2 loops. Code looks something like this:

$query = "SELECT * FROM TABLE1";
$result = @mysql_query ($query);

while($row = @mysql_fetch_array($result))
{
echo $row["NAME"];
echo '<br>';

$Name = $row["NAME"];
$query2 = "SELECT * FROM TABLE2 WHERE TABLE2.REFNAME='$Name';
$result2 = @mysql_query ($query2);

while($row2 = @mysql_fetch_array($result2))
{
echo $row2["REFNAME"];
}
echo '<p> </p>';
}


Slack




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users