Insert record session variable error

I used the data assist insert record function and I am able to upload to database. However, when I then use the session variable created by the insert record on another form (different page) it does not transfer the previously entered value, rather it places a "0". I only have one field in the database that I am using the insert record behavior. Any advice would be great. Thanks

on the page you are using the session, add the following at the top:

<?php if(!session_id()) session_start(); ?>

I pasted the php code you suggested and I still get a "0" in the text field. However, if I place MM_Username session variable in the text field I do get the correct user. The MM_Username var is being generated on another page (pg1). The session variable that I am having problems with is being generated on pg2 (this is being done through the dataassist insert record) I can get the MM_Username to display on pg3 but not the session variable that I am generating on page 2.

please send a copy of your pages in a zip archive so I can see the code.

Attached zips

It looks like you are setting the value for the ID column manually.

you should be doing this.


the id column of the table should be set to be an Auto Number column so that the mysql engine can handle assigning it's value.

The id value is the name of my form text field that I'm inserting into table.
That is the only field in the table.
It is manually written because it is a form that asks for that information. I just want to display it on the next page, as it is being written to table in mysql.

you should have an id column that is an auto number column, then a second column for the data to be entered to.


The proper way to create a database table is to create an auto number field for the Primary Key column


user entered data should not go into the primary key column for the table.

Thank you. That was the problem.

you're welcome.