Keeping select list persistent

j_70

I grab data from an Oracle database and create a select list as follows:

 while ($row = oci_fetch_array($stid, OCI_RETURN_NULLS)) {
   print '<option value="'.$row[0].'">'.$row[1].'</option>';       

  }

The problem I have is that my error handling functions send the user back to the same form if there is a data entry problem. When this happens, I get an error that the login information (that I use to build the select list) is incorrect; basically because it is gone.

Rather than going back to the database each time the user is sent back to the form for a data entry error, is there a way to make this list persistent. TIA.

Roger_Ramjet

Sessions

j_70

I am using sessions. For some reason, when the browser is redirected back to the same page, the session is not honored. I do not have this problem passing session information between pages.

Sxooter

How are you doing sessions? get url or cookie based?

j_70

POST request.

Sxooter

You can do sessions with post requests? I hadn't heard of that. Man, I gotta read up on php again. I've been living in a java world for too long. Someone else got any advice on what's happening? I'm guessing that a redirect loses all your post data.

You might need to use cookie based sessions to get around this.

Roger_Ramjet

Or could it be that you are not saving the data into a session var in the first place?

j_70

I have all the database connect information in session variables so my expectation was that even if the page refreshes and an attempt is made to re-establish the database connection, the information to do that is there. It is available in the next page but seems to get lost in this page. Same session though.

Roger_Ramjet

OK, somehow or other I get the feeling that you do not understand sessions and how they work. Look, you are just going to have to post the actual code so we can see what is going on. Otherwise forget it - we turn our mid-readers off after 6.