INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

E-mail*
Handle

Password
Verify P'word
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Member Feedback

"...This is easily the most helpful website I've ever used, and this is the best forum with the quickest response time bar none...."

Geography

Where in the world do Tek-Tips members come from?

 3D computer game comparison database design

Eep2 (Programmer)
19 Oct 02 19:42
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_models/games_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.php?s=&threadid=44669

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10212317

http://www.phpbuilder.com/board/showthread.php?s=&postid=10236364

http://forums.devshed.com/showthread.php?s=&threadid=44502

Any help would be greatly appreciated. I really need as thorough table structures as possible. Thanks!

Start A New Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Promoting, selling, recruiting and student posting
are not allowed in the forums.
Posting Policies

LINK TO THIS FORUM!
(Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum)
TITLE: -General database discussion Forum at Tek-Tips
URL: http://www.tek-tips.com/threadminder.cfm?pid=669
DESCRIPTION: -General database discussion technical support forum and mutual help system for computer professionals. Selling and recruiting forbidden.