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)";
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 />
I'd like the data to come out in the way I have listed. Where am I going wrong?