table with 4 columns
STATE CATAGORY VISITORNUMBER PAGECOUNT
Each new visitor is asigned a number IE: $hits
the visitor then clicks on a link with the $state varible embedded in it. I then need search VISITORNUMBER to find one that matches $hits and inputs the varible $state into the STATE column so I have a database record of Visitor number ($hits) and what link they clicked on ($state)
They will later click on a catagory link which will put into CATAGORY acording to thier $hits number ect ect so I can build up a profile of where they are and where they have been
they may also later click on link changing $state again so it will have to find thier $hits number again and change the STATE catagory to a new $state again.
i hope this explains it well enough