Having trouble displaying JOINed query data

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
mkenyon2
Forum Newbie
Posts: 2
Joined: Tue May 19, 2009 11:19 am

Having trouble displaying JOINed query data

Post 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?
Last edited by Benjamin on Tue May 19, 2009 11:57 am, edited 1 time in total.
Reason: Added [code=php] tags.
Post Reply