Combine Code

D_tunisia

I have these two sets of code (shown below) I want to make the second one run within the WHILE loop of the first. Is there anyway to do it?

<?php

include ("dbConfig.php");

$result = mysql_query("SELECT * FROM posts");

echo "<table border=0>\n";

while ($myrow = mysql_fetch_row($result)) {

	printf("<tr><td><font face=verdana size=2><b>%s</b><br><font face=verdana size=1>Posted by %s<br><br><font face=verdana size=2>%s<br><a href=\"comment.php?id=%s\">Comment on this post</a> - <a href=\"view_comments.php?id=%s\">View comments about this post</a><br><br></td></tr>\n",
	$myrow[2], $myrow[1], $myrow[3], $myrow[0], $myrow[0]);

}

echo "</table>\n";

?>

<?php

include ("dbConfig.php");

$result = mysql_query("SELECT * FROM comments WHERE post_id='$id'");

while ($myrow = mysql_fetch_row($result)) {

	printf("%s <b>- %s</b><br><br>",
	$myrow[3], $myrow[1], $myrow[0] );

}


?>

sid

without actually optimizing the queries, i think this should be about what you are looking for:

<?php 

include ("dbConfig.php"); 

$result = mysql_query("SELECT * FROM posts"); 

echo "<table border=0>\n"; 

while ($myrow = mysql_fetch_row($result)) { 

    printf("<tr><td><font face=verdana size=2><b>%s</b><br><font face=verdana size=1>Posted by %s<br><br><font face=verdana size=2>%s<br><a href=\"comment.php?id=%s\">Comment on this post</a> - <a href=\"view_comments.php?id=%s\">View comments about this post</a><br><br></td></tr>\n", 
    $myrow[2], $myrow[1], $myrow[3], $myrow[0], $myrow[0]); 

    if ($id == $myrow[0]) {
        $innerresult = mysql_query("SELECT * FROM comments WHERE post_id='$myrow[0]'"); 

        while ($innerrow = mysql_fetch_row($innerresult)) { 

                printf("%s <b>- %s</b><br><br>", 
                $innerrow[3], $innerrow[1], $innerrow[0] ); 

        } 
    }
} 

echo "</table>\n"; 

?>

D_tunisia

Thanks, with a bit a tinkering I got that to work. But at the moment it displays every result from the second query at the top of the page (above the first query!).

I want to display the results for the post_id of the second query below the relevent result of the first. If that makes sense!