I am setting up a table to log a count on individual records for every time they are returned in a results return. Just so to illustrate Record1 First search brings up Record1 (counter is set too 1) Second search brings up Record1 (counter is set too 2) Third search brings up Record1 (counter is set too 3) ...etc. So I have a vauge idea of the sql statement but where to place is the question. My thoughts are that it should be in the loop that generates the result rows return. In other words - Maybe here : <?php echo $row_rsVJ['JobTitle']; ?></div></td> Or maybe here ?: <?php } while ($row_rsVJ = mysql_fetch_assoc($rsVJ)); ?> Hope what I'm asking is clear. Thank you , Stuart -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php