Hello,
The code below works great. It combines data from two
MySQL tables. I would like
to modify it by pulling in some data from a third
MySQL table called "comment."
In the HTML table below, "title" is a field in the
MySQL table "submission." Every "title" has a corresponding "submissionid" field. The field "submissionid" is also found in the "comment"
MySQL table.
In the HTML table below, I would like "countComments"
to equal the number of times a field called "commentid" appears in the
MySQL table "comment" for any given "submissionid," where the "submissionid" is the same in both the "submission" and "comment" tables, and where the "submissionid" corresponds
to the "title" being used.
Here's the catch: if there is no row in the
MySQL table "comment" that corresponds with the "submissionid" being used for "table", I would like "countComments"
to equal
to zero.
How can I do this?
Thanks in advance,
John
$sqlStr = "SELECT s.loginid, s.title, s.url, s.displayurl, l.username
FROM submission AS s,
login AS l
WHERE s.loginid = l.loginid
ORDER BY s.datesubmitted DESC
LIMIT 10";
$result = mysql_query($sqlStr);
$arr = array();
echo "<table class=\"samplesrec\">";
while ($row = mysql_fetch_array($result)) {
echo '<tr>';
echo '<td class="sitename1"><a href="http://www.'.$row["url"].'">'.$row["title"].'</a></td>';
echo '</tr>';
echo '<tr>';
echo '<td class="sitename2"><a href="http://www...com/sandbox/members/index.php?profile='.$row["username"].'">'.$row["username"].'</a><a href="http://www...com/sandbox/comments/index.php?submission='.$row["title"].'">'.$row["countComments"].'</a></td>';
echo '</tr>';
}
echo "</table>";
