POST data to MySQL problem

[lukep11a]

Hi, I am using MySQL version 5. Below is my table structure named 'selections':

 

id                 int(11)

username varchar(50)

selection1 varchar(30)

selection2        varchar(30)

selection3 varchar(30)

selection4 varchar(30)

 

I have a working register/login form that posts data to table called 'members'. Once a user logs in for the first time a series of pages are displayed, starting with teamselection1.php where the user will select 1 football team from a choice of 4 and then click submit which then POST's the data to the field 'selection1' of the 'selections' table and then teamselection2.php is displayed and so on.

 

I am having problems trying to get the username that has been used to login with to update in the same row of the 'selections' table and also at trying to get each team selection to update the same row in the 'selections' table. I am starting to wonder whether this is even possible. I hope I have explained this well enough. If anyone can help it will be very much appreciated.

 

Thanks in advance

Luke

[TrueColors]

You haven't explained properly, neither have you shown any code or explained your problem.

[dougjohnson]

You could put the logged in userid in a session variable?  Or just pass the userid as a hidden value in the POST?  Other than that I'm not sure what you're having trouble with.