SitePoint Sponsor

User Tag List

Results 1 to 1 of 1
  1. #1
    SitePoint Member
    Join Date
    Oct 2002
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    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 http://tnlc.com/eep/compare/table.html and http://tnlc.com/eep/compare/mentions.html (46 games so far), and allowing submissions via the still-being-designed game entry form at http://tnlc.com/eep/compare/gameform.html .

    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: http://tnlc.com/eep/compare/relations.jpg
    Later design (lots of cross-reference tables): http://tnlc.com/eep/compare/relations4.gif
    Latest cross-reference design: http://tnlc.com/eep/compare/relations5.gif
    Heirarchial design proposed by Barry White: http://www.databaseanswers.com/data_...ames_features/

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

    http://forums.devshed.com/showthread...threadid=44669

    http://www.phpbuilder.com/board/show...eadid=10212317

    http://www.phpbuilder.com/board/show...ostid=10236364

    http://forums.devshed.com/showthread...threadid=44502

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


Bookmarks

Posting Permissions

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