Copy link to clipboard
Copied
David, Thanks for all your help and I'm almost finished. Hopefully this will be the last item. I have users that register and then go to a profile page. I need them to be able to recieve multiple messages and also input multiple scores. I figured out how to do this but with only them being able to add one of each (its stored in the database table). How can store multiple items for each user (with users continuing to increase)? It's almost like I need a table for each individual user...
Copy link to clipboard
Copied
You do not need a table for each user. You would need to create a new table that stores the user details and has a foreign key to the user table. Before going any further I would urge you to stop what you are doing and learn about database design and normalization. A poorly designed database will give you headaches forever.
Copy link to clipboard
Copied
Thanks, but I will proceed. So getting back to my question...I figured that I needed a new table which I have. I also set up a user page based on the session MM_Username and that is working fine. I have 8 users in and everything is working fine on that end...that isn't the problem. I used the insert command to insert all data/foreign key into table2 that I needed. I need to be able to display a set of records from (table2) and when I try to use the MM_Username to filter that table, it doesn't work. My understanding was that when a user is logged in, the session for each page is MM_Username so if the tables are set up with the same information, why doesn't it work? I also inserted the table in the main loggin page and it actually does pull up the information, but even though I have the "repeat region command" it only shows the first record...it does however pull the first record for the logged in user. But doesn't work at all on another page. Please help.
Copy link to clipboard
Copied
Without supplied code it is impossible to determine what the problem may be.