Jump to content

[SOLVED] Display from Mutliple Tables


phpbeginner

Recommended Posts

I'm sure this is an easy one. I have links to a page which grabs a name from table and inserts the data to the page.....Ex: domain.com/pagename.php?view=NAME which works fine.

 

I am trying to insert data also from another table and can't seem to get it to work. Here is what I am doing.....

 

I am getting the data using  $rs=mysql_query("select * from tblxxxxWHERE name='$view'"); which works fine but then I am also trying to get the data based on the same $view as below..

 

$rs=mysql_query("select * from tblyyyyy WHERE team='$view'");

 

Any advice as the second one will not display any results. I am learning bit by bit and it looked to me as though this would work but obviously does not.

 

Thanks In Advance

 

Link to comment
https://forums.phpfreaks.com/topic/47144-solved-display-from-mutliple-tables/
Share on other sites

tbldivision and tblteam

 

When linking to this page I have it linking from tbldivision.

 

It links to this page ---->team.php?view=name

 

I then have records in tbldivision and tblteam I want to display based on the =name

 

The common field between these 2 is tbldivision fld name and tblteam fld team.

 

Thanks Eugene, I appreciate the help.

 

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.