in this instance, where a computer isn't likely to contain more than x drives, it may work, however, if he wants to later include sn's, and mfg's a separate table would be better.. :)
-- ======================================================================= 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/ "Chris Barnes" <[EMAIL PROTECTED]> wrote in message 000001c21ae8$b7ad7bd0$[EMAIL PROTECTED]">news:000001c21ae8$b7ad7bd0$[EMAIL PROTECTED]... > i dont know how will this will work, but you could try storing the multiple > hard disk details for each computer in an "array" in 1 field. > then when you want to get the information from the db, use explode() to > store the value in the field into an array again. > > e.g. > the field in the DB might look like this... > HardDriveSize = "1.2Gb,25Gb,25Gb" > > so get the field from the db and then use explode() to store it in an array > in php. > e.g. > $disk_size = explode("," , $field); > > i dont know how well this will work for you...i'm only a newbie. > > > -----Original Message----- > From: Mike Tuller [mailto:[EMAIL PROTECTED]] > Sent: Monday, 24 June 2002 3:43 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Question > > > 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. > > ComputerID > HardDriveType > HardDriveSize > > 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 > > ComputerID > DriveID > ------------------------ > Drive Table > > DriveID > HardDriveType > HardDriveSize > > 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? > > Thanks, > Mike > > > -- > 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