[RESOLVED] Loops

[th88]

Hi,

I would like to display the comments in a database for each news_id. e.g.

1
Jimmy Jones - This is a comment - [delete]

2
Jimmy Jones - This is a comment - [delete]
Jimmy Jones - This is a comment - [delete]

3
Jimmy Jones - This is a comment - [delete]
Jimmy Jones - This is a comment - [delete]
Jimmy Jones - This is a comment - [delete]
Jimmy Jones - This is a comment - [delete]

etc.

I have something that looks sort of like it!...

1
Jimmy Jones
This comment should only appear on article 1
delete

2
tom
comment on article 2
delete

2
jimmy jones
article comment
delete

2
tommy h
its me!
delete

created from:

<?php
//display the current news comments
$query = "SELECT news_id, name, comment FROM news_comments ORDER BY news_id";
$result = mysql_query($query) or die('Error : ' . mysql_error());
?>
<br/><br/>

<?php
	while(list($news_id, $name, $comment) = mysql_fetch_array($result, MYSQL_NUM))
	{
		?>
			<?php echo $news_id?><br/>
			<?php echo $name;?> <br/>
		    <?php echo $comment;?><br/>
		    <a href="javascript:delArticle('<?php echo $id;?>','<?php echo $name;?>');">delete</a><br/>

	<br/>
	<br/>


<?php

} //finishes the above while loops
?>

How would I adapt the above to get my desired output? I think I might need a loop for each news_id, then a loop within that for each comment associated to that news_id? Any help much appreciated.

Kind regards.

[kkobashi]

$query = "SELECT news_id, name, comment FROM news_comments ORDER BY news_id";
$result = mysql_query($query) or die('Error: ' . mysql_error());

while(list($news_id, $name, $comment) = mysql_fetch_array($result, MYSQL_NUM)) {
   echo $news_id . "<br/>";
   echo $name . " - " . $comment . " - " . "<a href=\"javascript:delArticle('{$news_id}','{$name}');\">[delete]</a><br/>"
}

[th88]

khobashi, thanks for your reply but that actually gives me the same as what I currently have (as it's echoing the news_id for every comment).

What I want to end up with is:

1
Jimmy Jones - This is a comment - [delete]

2
Jimmy Jones - This is a comment - [delete]
Jimmy Jones - This is a comment - [delete]

3
Jimmy Jones - This is a comment - [delete]
Jimmy Jones - This is a comment - [delete]
Jimmy Jones - This is a comment - [delete]
Jimmy Jones - This is a comment - [delete]

Kind regards.

[NogDog]

One way:

$data = array();
while(list($news_id, $name, $comment) = mysql_fetch_array($result, MYSQL_NUM))
{
   $data[$news_id][] = array('name' => $name, 'comment' => $comment);
}
foreach($data as $id => $comments)
{
   echo "<h3>$id</h3>\n";
   foreach($comments as $comment)
   {
      echo "<p><b>{$comment['name']}:</b><br />{$comment['comment']}</p>\n";
   }
}

[kkobashi]

I misread your message. What I thought you wanted was to line up everything and format it on one line:

id
name - comment - [delete]

Your output was:

id
name
comment
[delete]

So I thought thats what you wanted.

Your question would have been better understood if you would have said that you wanted to show a list of what messages a user commented on...

[th88]

NogDog, works perfect, thanks so much.

Kkobashi, I think I was as clear as I could be (gave current output, desired output and current php). Thanks anyway.