Updating count on record results
| From: | Stuart Felenstein | Date: | Fri, 19 Nov 2004 12:59:20 +0000 |
| Subject: | Updating count on record results | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-37356@lists.php.net to get a copy of this message | ||
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