cache and refresh problem

peeter_talvistu

hi all,

i have astrange problem with php and mysql. i have two frames, one of which contains a list of users and the other one is used to display the selected user's information in a form. the list refers to the other frame via a link edituser.php?id=$id

the form page gets the id data from database, build an array and uses a function to build the form. the problem is that sometimes when i click first one user in the list and then another one the form is still populated with the values of the user which i clicked first. when i echo the $HTTP_GET_VARS['id'] in the beginning it has changed but the form still shows old values.

the only way i can show the right values is either by clicking the second user again or by refreshing the form page.

i don't know where the roots of this problem are. my first thought was that maybe the server somehow remembers the array (holds it in memory) but then i unset all arrays after they were used and that didn't work. then i tried to work with cache controling but that didn't work either.

so if anybody has encountered this problem or knows a workaround, i would greatly appreciate a solution.

peeter

peeter_talvistu

ok, since no one has replied, i try to ellaborate.

this problem is happening on two servers - my one machine (localhost based on windows) and a large webserver (based on linux). the php and mysql versions on these two servers are different - so no version specific problem.

it seems that a) the page with the form is taken from browser cache, b) the array that i use to build the form is kept in memory, or c) mysql or php somehow uses the previous query to create the from.

a) i am using all the nessecary http headers to prevent caching (pragma, cache-control and expiring date set to 1980). i have also turned off every cache option in the browser. however, when i use mozilla to view the page info, it says that source of the page is memory cache.

b) at the end of the function that builds the form from the arrays i unset all the array variables. if i try to access them with php after the function has ended, they don't display.

c) when i check the id that is used for the mysql query and that it obtains from get variables ($HTTP_GET_VARS['id']) before the mysql query it shows the new id. but when i check the id that was obtained from the query, the id is the old one. so it is quite possible that somehow the old query (or the result of it is used). this happens even if i unset the $sql variable that i use to do mysql_query or give it a value of = "";

to me it seems that c) is the culprit. but i have never encountered a similiar error so i don't know how to solve it. if anybody does, please reply.