Thanks for all of the advice. I am learning, and want to learn the right
way, and all the advice given will benefit me greatly in the long run. I
wish there was an easier way to deal with relationships in MySql, but I am
sure that will come along in time.
> From: "Tracker 1" <[EMAIL PROTECTED]>
> Date: Mon, 24 Jun 2002 01:57:17 -0700
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Re: Question
> you are thinking backwards..
> drives 1-> computers
> iCompID As BigInt Primary Key Autonumber,
> sCompName As VARCHAR(25)
> iDriveID As BigInt Primary Key Autonumber,
> iComputerID As BigInt Not Null,
> Foreign Key fkDriveComputer (iCompID) References tblComputers(iCompID)
> note, you need to use InnoDB tables in mysql for foreign key references
> to work properly, you should do it in your code anyway..
> select * from tblComputers
> for each rsComp..
> select * from drives where iComputerID = (rsComp.iCompID)
> there you go.. :)
> Michael J. Ryan - tracker1[*at*]theroughnecks.com
> Roughneck BBS: http://www.theroughnecks.net telnet://theroughnecks.net
> Y!: aztracker1 - aim: azTracker1 - icq: 4935386 - msn: see email
> One program for aim/icq/yahoo/msn/irc - http://www.trillian.cc/
> "Mike Tuller" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>> I am wanting to create a PHP frontend to a database that holds information
>> about the computers that I take care of. I have a problem though when it
>> comes to storing hard drive information. In most cases, the computers have
>> one drive, but some have 2 or more, so I can't create the main database with
>> fields like this.
>> I know I will need to create a separate table to hold information about the
>> drives, and connect them to the computer by attaching the primary key of the
>> drives table to the Computer table.
>> Computer Table
>> Drive Table
>> This is where I am unsure. If there is more than one drive, then this would
>> be incomplete because it would only show one drive. What is the best way to
>> make it so that all drives show for the computer, or am I doing this
>> backwards? Should I tie the computer to the drive instead?
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php