data from one table to another

[Guest_imported]

I am trying to get a member id numbers from one table to go into another table when they submit a form. If anybody has any suggestions it would really help.

 

[EugenePaliev]

Hello guest256!

What tables do you mean? Data base's or HTML's tables?
I'll think you're talking about DB table.

There are number of ways how you can do this and noone is perfect:

1) store ID value in a Session variable.
+ it's the safest way - noone can access this value accept your application;
- Session object is available only if user's cookeis are enabled.

2) store in client's cookies (works similar to Session but Session is preferable):
+ basicly it can be accessed only from your server (but it's not an absolute seccurity);
- cookies can be disabled.

3) store it in hidden field of FORM in your HTML page:
<input type=&quot;hidden&quot; value=&quot;userID&quot;>
+ it works always;
- it can be accessed by unauthorised persons just by simply viewing source code;

4) pass it via URL (often securely encoded):


So you see that there are different ways to pass userID and noone is perfect. Some people combnine these ways.
I use Session object to keep userID and when cookies are disabled encode it and pass via URL or hidden field.

Good Luck!