Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2010

    SQL relationships

    Hi this my first post here and am looking forward to using dbforums

    I am developing a online formbuilder where users, once registered can create and manage just their own forms. I have the mySql form tables created that are imputed with forms details, id, elements etc, and have created the 'user/registration' table so users can login

    What I need is some help on how to build the relationship between the user table and the form tables, so they are assigned to their form

    Once logged in users id is tracked with a cookie, and I presume that the users table uses a one to many relationship, but how can I implement this in my sql

    I hope I have explained this OK, thanks in advance


  2. #2
    Join Date
    Aug 2010
    Welcome. You need an id in the forms table refering to the same id in ther users table.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts