lukep11a Posted June 13, 2011 Share Posted June 13, 2011 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 Quote Link to comment https://forums.phpfreaks.com/topic/239285-post-data-to-mysql-problem/ Share on other sites More sharing options...
TrueColors Posted June 13, 2011 Share Posted June 13, 2011 You haven't explained properly, neither have you shown any code or explained your problem. Quote Link to comment https://forums.phpfreaks.com/topic/239285-post-data-to-mysql-problem/#findComment-1229302 Share on other sites More sharing options...
dougjohnson Posted June 13, 2011 Share Posted June 13, 2011 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. Quote Link to comment https://forums.phpfreaks.com/topic/239285-post-data-to-mysql-problem/#findComment-1229303 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.