AnthonyP
11-28-2004, 02:03 PM
hi everyone,
Been a while since I been last here, but it's really nice to be back. :) Anyways... here is the situation. I have a script that displays the information of the people that enter my personal site. The script is run on an Access DB.
So I can explain the prople more clearly, here are some of the features of the script and how it works:
When a user logs into the site for the first time, a cookie is created ON the login script itself and then that user is marked as a known user. For example, this is a very small personal site, so only family and close friends use it. The DB is given the following info:
DATE
USER
(CLIENT ID)
BROWSER
TAG (must be set manually)
IP
CREATE (ONLY a value "yes" is eneterd when first cookie is created)
..and some other few tables.
The three most important sections are the CLIENT ID, TAG and CREATE. The CLIENT ID is the unique random number ID that the user gets the first time they log on. That ID will be used to identify that user every time they log in after that. TAG is a not I can manually enter to the DB to describe the record. For example, since I always use the same browser and thus always the same CLIENT ID, I gae myself a TAG called "ME, MSIE Home Comp), so when I look in the log, I should be able to check which computer I used to log in on a later date, for example. CREATE sets a value "yes" into the database when the cookie is created for the first time. Everyother time, when the cookie is reused, no data is entered here.
The problem with the script is that I am using some code I got help with from putts a while ago, and this code allows me to split up the results of the DB that get displayed in the table into pages. Because of this process, another important process gets interrupted.
That important proces has to do with TAG. On the final page, in the row for each record with "yes" in the CREATE field, there is a link to clikc on that allows me to add the TAG data for that CLIENT ID. So then, when the script reads the TAG data, it puts this into a 3 dim array that also stores the corresponding CLIENT ID. So everytime that specific CLIENT ID appears in the future, the script will also write the relevant TAG for it. This is done with a simple for next loop.
Now, if each page displays for example 10 listings, and the CREATE is not among those 10. Then the TAG information is not in the array because the array reads only those 10. What I need to do is get the script to read ALL the values to find the matches. Also, since the script works from top to bottom through the DB, I can't display the records in descending order because then the repeat logins get recorded before the initial CREATE, so they dont get listed into the array. So i end up having to use default ascending order which makes all the latest records go to the last page.
WHAT I need to do right now is get the script to display all my data in descending order where the latest entries in the DB are at the top first page and I need the script to be able to read all the create tags first, then have the values in an array with the CLIENT ID, so that all the repeat logins will have access to that array to dsplay the right TAGs in the right CLIENT IDs.
I hope this explanation isnt confusing! lol.. Any help at all will be greatly appriciated! Thanks in advance guys! If you ca't help me, I still appriciate you takign the time to read this far.. :) Thanks
Anthony
P.S. I will paste the code in another post! Message too long error! :P
Been a while since I been last here, but it's really nice to be back. :) Anyways... here is the situation. I have a script that displays the information of the people that enter my personal site. The script is run on an Access DB.
So I can explain the prople more clearly, here are some of the features of the script and how it works:
When a user logs into the site for the first time, a cookie is created ON the login script itself and then that user is marked as a known user. For example, this is a very small personal site, so only family and close friends use it. The DB is given the following info:
DATE
USER
(CLIENT ID)
BROWSER
TAG (must be set manually)
IP
CREATE (ONLY a value "yes" is eneterd when first cookie is created)
..and some other few tables.
The three most important sections are the CLIENT ID, TAG and CREATE. The CLIENT ID is the unique random number ID that the user gets the first time they log on. That ID will be used to identify that user every time they log in after that. TAG is a not I can manually enter to the DB to describe the record. For example, since I always use the same browser and thus always the same CLIENT ID, I gae myself a TAG called "ME, MSIE Home Comp), so when I look in the log, I should be able to check which computer I used to log in on a later date, for example. CREATE sets a value "yes" into the database when the cookie is created for the first time. Everyother time, when the cookie is reused, no data is entered here.
The problem with the script is that I am using some code I got help with from putts a while ago, and this code allows me to split up the results of the DB that get displayed in the table into pages. Because of this process, another important process gets interrupted.
That important proces has to do with TAG. On the final page, in the row for each record with "yes" in the CREATE field, there is a link to clikc on that allows me to add the TAG data for that CLIENT ID. So then, when the script reads the TAG data, it puts this into a 3 dim array that also stores the corresponding CLIENT ID. So everytime that specific CLIENT ID appears in the future, the script will also write the relevant TAG for it. This is done with a simple for next loop.
Now, if each page displays for example 10 listings, and the CREATE is not among those 10. Then the TAG information is not in the array because the array reads only those 10. What I need to do is get the script to read ALL the values to find the matches. Also, since the script works from top to bottom through the DB, I can't display the records in descending order because then the repeat logins get recorded before the initial CREATE, so they dont get listed into the array. So i end up having to use default ascending order which makes all the latest records go to the last page.
WHAT I need to do right now is get the script to display all my data in descending order where the latest entries in the DB are at the top first page and I need the script to be able to read all the create tags first, then have the values in an array with the CLIENT ID, so that all the repeat logins will have access to that array to dsplay the right TAGs in the right CLIENT IDs.
I hope this explanation isnt confusing! lol.. Any help at all will be greatly appriciated! Thanks in advance guys! If you ca't help me, I still appriciate you takign the time to read this far.. :) Thanks
Anthony
P.S. I will paste the code in another post! Message too long error! :P