Page 1 of 1

Having trouble displaying JOINed query data

Posted: Tue May 19, 2009 11:24 am
by mkenyon2
I'm used to the MS SQL/.Net world, so please bear with me.

I'm trying to do this query:

Code: Select all

 
    $peevequery = "SELECT Peeves.*, PeevesKeyWords.Keyword FROM Peeves INNER JOIN (PeevesKeys, PeevesKeyWords)
ON (Peeves.PeeveID = PeevesKeys.PeeveID AND PeevesKeys.KeyWordID = PeevesKeyWords.KeyWordID)";
 
And display it here:

Code: Select all

 
// Display pet peeves
$peeveresult = mysql_query($peevequery);
while ($row = mysql_fetch_array($peeveresult, MYSQL_ASSOC)) {
    if ($peeveId == "")
        $page_title = "All";
    else
        $page_title = $row['Title'];
    
    $page_body += "  <h3>Pet Peeve - {$row['Peeves.Title']}</h3>
     {$row['Peeves.Description']}<br />";
//   - {$row['PeevesKeyWords.Keyword']}<br />";
} // End of while loop.
 
Then later I do this to output $page_body
<?php 
    echo $page_body;
?>
<br />
 
If I run the query from a mySql query window, I get 5 rows. 3 rows are in the Peeves table, but 2 of those rows have 2 keywords.

I'd like the data to come out in the way I have listed. Where am I going wrong?