Views 2.x - creating table of unread comments
Im quite new in using views module and Im quite sure this request is quite basic but Ive spent around 2 days searching thru the database of drupal.org finding no answers. Since this is somewhat a newbie question.
I would like to create a table of unread comments. Based on my research, this is best and easily done by Views module. Ive got it halfway working but got stuck on 2 issues.
Problem #1
Unread comments are being listed every instance rather than just the latest one. For example, if a page node has 5 new unread comments since last visit, this should be listed by views as 1 entry rather than 5 times. What should be in the filter to just show the latest unread comment of a node?
Problem #2
I would also like to filter out comments by the current logged in user. I know I should be filtering author id or name but how to do this since the current logged user is not a constant name. I tried:
- did not work
$user - did not work either
<?php
$user ->name; $myID = $user; echo $myID
?>.... and countless variations
Test site using views 2.x on drupal 6.9. Since this is somewhat a newbie question, was hoping of getting some help from friendly kababayans rather than risk getting flamed posting this question on drupal.org.