[PHP] How can I do this?? :((

[Sandeep Hundal]

Hi all,

I'm basically really struggling with this query, so would appreciate
any pointers on how I could do this. I've included my experimental
code underneath, and need to make it work. 
The first query, which I know works, pulls info from a mysql table. 

Now for each of my diary entry, I want people to be able to add
comments. All comments go into another table which records what
section that comment came from (which is diary), and the id (which it
takes from the id number of the diary entry).

Now what I want to do is have another query which asks the second
table the number of comments per each section id, for that section,
(and I think QUERY2 does this fine). But I need the answers to
integrate with the information pulled from first query. How can I
intergrate the results from 2 queries into one basically!


CODE
***************************
$query1 = " SELECT entry FROM diary WHERE month='$month' ORDER BY id
desc";
$result1 = mysql_query($query1);

$query2 = "SELECT count(*) AS replies FROM sexsurvey_boys WHERE
section='diary' GROUP BY sectionid ORDER BY sectionid desc";
$result2 = mysql_query($query2);

if ($result1) {
echo "<table border=0 cellspacing=0 cellpadding=2 width=90%
align=center>";
        while ($r = mysql_fetch_array($result)) {
        extract($r);
        $entry = nl2br($entry);
        echo " 
<tr bgcolor=#ffffff><td colspan=2>$entry<br></td></tr>
<tr bgcolor=#ffffff>
      <td>&raquo; <a
href=\"javascript:popupwin('popupwindow.php?section=diary&sectionid=$id',200,530)\">comment
on this diary entry</a></td>
      <td align=right>read comments, (0) so far.</td></tr>
        ";
}
        }
        else {
                echo "Whoops!";
        }
mysql_free_result($result1);
*********************

TIA!
Sunny

__________________________________________________
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]