I'm sure this is very easy but i keep hitting a brick wall;
Using Dreamweaver MX2004
I have 2 tables : Athlete and performance
athlete; athlete_id, athlete_name, athlete_email, athlete_password, athlete_no
performance; log_id. athlete_id, log_date, log_event, log_perf, log_venue
So far I have created a login page that creates a session variable that holds the athlete email, I have created a update user page, change password page etc. I used the php login suit extension to do this.
I problem I am having is when I try to build a page that inserts data into the performace table. I want the page designed so when the user login's in they simply enter[log_date, log_event, log_perf, log_venue]. I don't want the athlete to enter their athlete_id every time they input a new performance. Can the athlete_id be held in a session variable when they login and used when they enter a new performance.
The login page created the following code to create the sesion variable>
$HTTP_SESSION_VARS['login_sac'] = $HTTP_POST_VARS['textfield'];
Any help would be great, this is frying my head has i'm sure the solution is easy...
Thanks in Advance