Retrieving Data (Assign Variables To Array)

Alright, I’ve been working on this profile system thing for (no lie) almost a year… currently 3 days with barely any sleep.. I have the information collecting and storing part DONE. Now, my issue is with retrieving and displaying the data from the two databases in the user’s profile. There are 2 database tables: test_users and test_profile.

Test_user contains:
id
login
password
display_name
pass_hint
email
tmp_email
active

Test_profile contains:
id
users_id
language
name
age
sex
country
homepage
interests
pic
user_1
user_2
user_3
user_4
user_5
user_6
user_7
last_change

Now, I’m having trouble mainly with the class that handles session creation and login info, I don’t know what all is stored in the session (this isn’t my script and I’m not familiar with classes). [URL=http://users.dreammare.net/access/codehelp.html]This is the link to a textbox that contains the access_user_class and the profile template[/URL]. Oh yeah, I also don’t know how to properly code the array. What I need is to fetch all the data from a row (info belonging to the user who is currently logged in) and assign each piece of data that is retrieved a variable to be called later by the profile. What I do NOT want is to pull the data from the table and then echo or print it out right after the query. This is probably really confusing, and I’m sure the answer is quite easy, but again, 3 days(-sleep)+(3 hours of searching this forum)=- energy. Thanks in advance!

Also in #PHP _↴