MySQL

Getting results from using 2 tables

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Nov 2008

Posts: 20

Reputation: stevehart808 is an unknown quantity at this point

Solved Threads: 0

stevehart808 stevehart808 is offline

Offline

Newbie Poster

Getting results from using 2 tables

Dec 9th, 2008

Hi can someone shed some light on this problem I'm having please?

2 tables

SHOWS_ARCHIVE (TABLE 1)

ID
SHOW_ID
AUTHOR

SHOWS (TABLE 2)

ID

When the member logs in they are a loud to see their shows because of the $author permissions;

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
 
if ($_SESSION['MEMBER_PERM'] == "2")
					{
$author = $_SESSION['MEMBER_ID'];
 
$sql = mysql_query("SELECT * FROM show_archive WHERE author = $author");
					}
if ($_SESSION['MEMBER_PERM'] == "2")
					{
$author = $_SESSION['MEMBER_ID'];

$sql = mysql_query("SELECT * FROM show_archive WHERE author = $author");
					}

but I want to do is see the results using the SHOWS table ID as well. ie

Help with Code Tags

(Toggle Plain Text)

if ($_SESSION['MEMBER_PERM'] == "2")
					{
$author = $_SESSION['MEMBER_ID'];

$sql = mysql_query("SELECT * FROM show_archive WHERE author = $author AND show_id = `shows` id");
					}

•

Join Date: Dec 2008

Posts: 11

Reputation: indianrock9 is an unknown quantity at this point

Solved Threads: 0

indianrock9 indianrock9 is offline

Offline

Newbie Poster

Re: Getting results from using 2 tables

Dec 10th, 2008

Hi,
Try the following:

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
if ($_SESSION['MEMBER_PERM'] == "2")
  {
     $author = $_SESSION['MEMBER_ID'];
 
$sql = mysql_query("SELECT *, * FROM show_archive, shows WHERE author = $author AND show_id = `shows` id");
					}
if ($_SESSION['MEMBER_PERM'] == "2")
  {
     $author = $_SESSION['MEMBER_ID'];

$sql = mysql_query("SELECT *, * FROM show_archive, shows WHERE author = $author AND show_id = `shows` id");
					}

That should help you retrieve data from 2 tables at the same time. Let us know how it works.

•

Join Date: Nov 2008

Posts: 20

Reputation: stevehart808 is an unknown quantity at this point

Solved Threads: 0

stevehart808 stevehart808 is offline

Offline

Newbie Poster

Re: Getting results from using 2 tables

Dec 10th, 2008

Thanks but getting an error from that code.

•

Join Date: Nov 2008

Posts: 20

Reputation: stevehart808 is an unknown quantity at this point

Solved Threads: 0

stevehart808 stevehart808 is offline

Offline

Newbie Poster

Re: Getting results from using 2 tables

Dec 10th, 2008

Found the solution!

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
SELECT * FROM show_archive, shows WHERE show_archive.show_id = shows.id
SELECT * FROM show_archive, shows WHERE show_archive.show_id = shows.id