Re: [PHP] Re: Everything works...Unless they hit the "back" button...

2005-08-05 Thread Kristen G. Thorson
Jack Jackson wrote: Kristen G. Thorson wrote: You said "If the user makes changes, those changes get error checked but do not become part of the sql query." Where in your code is it failing to become part of the query? Put a check at each level and see where *exactly* it fails to get deep

Re: [PHP] Re: Everything works...Unless they hit the "back" button...

2005-08-05 Thread Jack Jackson
Kristen G. Thorson wrote: You said "If the user makes changes, those changes get error checked but do not become part of the sql query." Where in your code is it failing to become part of the query? Put a check at each level and see where *exactly* it fails to get deep enough to become one wi

Re: [PHP] Re: Everything works...Unless they hit the "back" button...

2005-08-03 Thread Kristen G. Thorson
You said "If the user makes changes, those changes get error checked but do not become part of the sql query." Where in your code is it failing to become part of the query? Put a check at each level and see where *exactly* it fails to get deep enough to become one with the query. Also, I'm c

Re: [PHP] Re: Everything works...Unless they hit the "back" button...

2005-08-03 Thread Jack Jackson
I've tried playing with the $_SERVER['HTTP_REFERER'] and that's no good because it's all coming from the same page - index.php!! What am I missing. . . ? Jack Jackson wrote: Hi Kristen, there's a misunderstanding: Kristen G. Thorson wrote: The code below isn't much help to debug. Do some c

Re: [PHP] Re: Everything works...Unless they hit the "back" button...

2005-08-03 Thread Jack Jackson
Hi Kristen, there's a misunderstanding: Kristen G. Thorson wrote: The code below isn't much help to debug. Do some checking to figure out how far into your IF statement you're getting. Is the query running? Yes it runs successfully Is it the query you expect? Yes it is perfect, and pr

Re: [PHP] Re: Everything works...Unless they hit the "back" button...

2005-08-03 Thread Kristen G. Thorson
The code below isn't much help to debug. Do some checking to figure out how far into your IF statement you're getting. Is the query running? Is it the query you expect? (Step #1 when inserting or creating dynamic queries that aren't working: print them out to make sure they are what you thi

Re: [PHP] Re: Everything works...Unless they hit the "back" button...

2005-08-03 Thread Jack Jackson
Hi, mark, Mark Rees wrote: > Do you want to allow people to go back and change things ? > If so, write a suitable UPDATE statement Thanks, but I think the update function should be built in -- the sql checks whether the userAnswer table contains the q_id the user has just entered; if so, it

[PHP] Re: Everything works...Unless they hit the "back" button...

2005-08-03 Thread Mark Rees
"Jack Jackson" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi all. This has been an interesting week. > > Now the form works, and I am able to error check, if no errors look into > user answer table and delete from that all q_ids matching the ones just > picked, insert this page o