[raptrex]

ive seen many tutorials that would display a post with its comments
but havent seen a tutorial that would display more than one post, and display all their comments

how would i do this?

[pgo]

In what CMS?

[raptrex]

in php, im making my own script

[Cborrow]

You can try something like this

<?php
	$dbh = mysql_connect("host", "user", "pass") or die("Could not connect to MySQL Server");
	mysql_select_db("db");
	
	$r = mysql_query("SELECT id,title,content FROM posts ORDER BY id DESC");
	
	while($o = mysql_fetch_array($r)) {
		$id = $o['id'];
		
		//Display your post
		
		$r2 = mysql_query("SELECT title,comment FROM comments WHERE post_id = '$id'");
		
		while($o2 = mysql_fetch_array($r2)) {
			//Display it's comments
			}
		}
?>

[raptrex]

thx cborrow very much, it works like a charm
except you need to change $r to $r2 here

while($o2 = mysql_fetch_array($r)) {
			//Display it's comments

cuz its comming from a different row
but other than that, thx