SitePoint Sponsor

User Tag List

Results 1 to 1 of 1
  1. #1
    SitePoint Member
    Join Date
    Oct 2002
    0 Post(s)
    0 Thread(s)

    Exclamation 3D game comparison database design HELP

    I'm trying to design a 3D computer game comparison database using PHP and MySQL, incorporating all the data in and (46 games so far), and allowing submissions via the still-being-designed game entry form at .

    Now, as you can see from the form, I want to allow people to enter custom fields in addition to the provided options (pull-down lists and checkboxes), but I'm having a hard time figuring out how to design that. Do I use "set" fields or cross-reference tables where keys are duplicated and the text-entry field data is entered in them or is there a more efficient way?

    Games can have more than one of just about everything.

    Original relationships:
    Later design (lots of cross-reference tables):
    Latest cross-reference design:
    Heirarchial design proposed by Barry White:

    Here are some discussions I've been involved in so far regarding this database in case you need more info/details:

    Any help would be greatly appreciated. I really need as thorough table structures as possible. Thanks!
    Last edited by Eep²; Oct 26, 2002 at 21:04.


Posting Permissions

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