[RESOLVED] Data from form, and quried Data Combined

shifty18

Hi, What i want to do is have a join form for a league so members can join differnt leagues. My problem

The user logs in, the session is created and the member has to be logged in to be able to view this page (members only page) so the session is created. Now i want them to be able to enter details for the league like times tehy can play, dates, skill level etc, but details like User Name, Name, Surname DoB are already in the Database.

I want these details along with the detrails they enterd into the form, to be added to a database, how can i take the data enterd, with data already enterd and combine together to make a record of both these 2 sets of infomation.

Do i need to query the database for the deired data, then simply add a new recod with the queried data, and the data enterd in to the form? But my user is already loged in with a session so can i hold the infomation in a session (or something) while the view, and then just pull that data from the session (or whatever) and use it, instead of qurying for the User name. and if i did ned to query for the data, i would need the user name so it knopws what record to pull from the DB so can i hold this username somewhere so it can be pulled if needed

Thanks
Chris

vaaaska

Yes...

As they are logged in you have their information. Query with that information to return their ID. Then, when a user enters information to the table just get the ID and insert it as well. Simple db relational stuff...

If that doesn't make sense...

tableID = 1
userID = 12
// then all of their input information as well

In your query, when you get all the information out you'll simply need something like...

SELECT * FROM users,info WHERE info.userID=users.ID AND tableID='$id'

Etc...good luck...v

shifty18

ok yeah thought it would be something along those lines. But I need to have the username first, they enter it when they login, but how can i store it so however many pages tehy visit i can pull it from somwhere if i ever need it. The varible needs to be stored somewhere doesnt it?

thanks

vaaaska

It's not so hard and you are on the right path. This is a really good article that will explain to you about simple login systems - I think you'll understand if you read this plus it has some handy source code to play with...

http://www.sitepoint.com/article/users-php-sessions-mysql

Good luck...v