Join

[SkyRanger]

Not sure if it is because it is too early in the morning but I am having a problem.

 

$mpid = #

$query = "SELECT table1.title, table2.* ".
"FROM table1, table2 ".
"WHERE table1.mpid = table2.mpid";

 

How do I only show the info from the 2 tables where mpid=#

 

 

 

[scootstah]

Something like

SELECT t1.title, t2.*
FROM table1 AS t1
JOIN table2 AS t2 ON t2.mpid = t1.mpid

[SkyRanger]

ok, will that only pull that data and display on the page where $mpid = #. 

 

for example mpid = 2 so only anything in the two tables that have a mpid of 2 will be displayed?

 

The reason why I ask is that I am learning on the fly and I don't see where it would pull the mpid that somebody would be requesting.

[dmikester1]

Adding to scootsah's code:

 

SELECT t1.title, t2.*
FROM table1 AS t1
JOIN table2 AS t2 ON t2.mpid = t1.mpid
WHERE t1.mpid = '2'

 

BTW, this is a MySQL question, not a PHP question.

[scootstah]

You can add a where clause for the first table, and then the JOINed table should only pull results based on what the first table's mpid matches.

SELECT t1.title, t2.*
FROM table1 AS t1
JOIN table2 AS t2 ON t2.mpid = t1.mpid
WHERE t1.mpid = '$mpid'

[SkyRanger]

awesome, perfect. thanks guys for your help.  It worked like a charm