Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
0

How do I add multiple information under an user account?

New Here ,
Sep 24, 2009 Sep 24, 2009

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...

TOPICS
Server side applications

Views

486
Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Sep 24, 2009 Sep 24, 2009

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.

Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Sep 24, 2009 Sep 24, 2009

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.

Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advisor ,
Sep 24, 2009 Sep 24, 2009

Copy link to clipboard

Copied

LATEST

Without supplied code it is impossible to determine what the problem may be.

Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines