Retrieving Post ID For Comments?

you can write a custom query:

SELECT comment_post_ID FROM $wpdb->comments WHERE comment_ID = '$comm->ID'

Would I do this instead of the $comments = get_comments ?

I don’t understand =p
the code that you gave in the first post works fine no?
but it will always display the same image linked by the meta …

The code works but the image will not. I want it to show the custom field that is attached to the post.

(I think ) Rahul Sonar was suggesting you to make an sql request to find the ID of the post, and, after, to use this ID to call your meta ^^

sql = "SELECT comment_post_ID FROM $wpdb->comments WHERE comment_ID = '$comm->ID'";
$image = get_post_meta($post->ID, 'photo', true);

$comments = get_comments('number=30');

Causes errors. Hmm, I am not seeing something here.

I don’t think you can do sql request like that lol [maybe it works in wordpress, but this is the first time I see that thing]
I’m using pdo to do my request, but try to look here : wpdb

try to use the ID that you will find in your call of the photo instead $post->id

I may be totally wrong about the solution… maybe Rahul Sonar was thinking about something else

Ive tried this somewhere once

$sql = "SELECT DISTINCT ID, post_title, post_password, comment_ID, comment_post_ID, comment_author, comment_date_gmt, comment_approved, comment_type, comment_content
		FROM $wpdb->comments
		LEFT JOIN $wpdb->posts ON ($wpdb->comments.comment_post_ID = $wpdb->posts.ID)
		WHERE (post_status = 'publish' OR post_status = 'static') AND comment_approved= '1'
		ORDER BY comment_date_gmt DESC
		LIMIT 30";
$comments = $wpdb->get_results($sql);

you can use this in stead of $comments = get_comments
the array $comments is populated with these values wich you can use in your function:

[ID] => 11 //this is the post ID
[post_title] => dolor
[post_password] =>
[comment_ID] => 12
[comment_post_ID] => 11
[comment_author] => admin
[comment_date_gmt] => 2010-07-23 09:43:39
[comment_approved] => 1
[comment_type] =>
[comment_content] => bla bla bla ...

I see now that $comments = get_comments('number=30'); also will give you the post ID [comment_post_ID] => 11
Put this inside the foreach statement of your function:

$image = get_post_meta($comm->comment_post_ID, 'photo', true);

Wow keesiemeijer, that worked pefectly. I just did your last idea and it worked. Here is the final code I have:

<?php
 $comments = get_comments('number=30');

 foreach($comments as $comm) :
  $image = get_post_meta($comm->comment_post_ID, 'photo', true);
  $url = '<a href="'. get_permalink($comm->comment_post_ID).'#comment-'.$comm->comment_ID .'" title="'.$comm->comment_author .' | '.get_the_title($comm->comment_post_ID).'">' . $comm->comment_author . '</a>';
?>
<li>
<?php echo get_avatar($comm->comment_author_email, 30); ?>
<strong><?php echo $url; ?></strong>
<p><?php echo $comm->comment_content; ?></p>

<img src='<?php echo $image; ?>' height='100' width='180' style='border:3px double white;' />
</li>
<?php
  endforeach;
?>