Re: page hit tracking

even simpler you could add a counter column to each vegetable table and increment it...that will save you an extra table. Jeremy "Ricardo Lopes" <lopes@elevaconsult.pt> wrote in message news:002e01c3ec93$41c8c450$5501000a@pnpgdom.net... > you could create a counter table and store there the vegetable id and the > hits. After that each time you search for a vegetable, make an update to the > table. > > ----- Original Message ----- > From: "js" <james@invividly.com> > To: <php-db@lists.php.net> > Sent: Friday, February 06, 2004 8:18 AM > Subject: [PHP-DB] page hit tracking > > > i am using php MySQL and i want to know how i can make a hidden value for > certain entries in a table and how many times they are called. for instance, > say i have a table of vegetables people can look at. the page displays all > of the vegetables, and then it generates links to each one and if the user > clicks on one then the page just calls itself and displays more information > about the vegetables. now, how do i make a counter where theres a field in > the table where it increases by 1 everytime someone looks at a particular > vegetable. i really am new to this so thank you for your help. thanks > -james