That would probably work, but only for what I want right now. If I ever wanted to create a report of all the hard drives I have, it would become more difficult.
I know I need to have a separate table in the database for the drives, but am not sure if the foreign key should be drives in the computer table, or computer in the drive table. I could just go ahead and work with it, but I am the type that wants to learn the right way in the beginning, not figure out later that I was doing it wrong. As far as normalization, ( In reply to Duncan's post) I have been reading up on that, and so far it hasn't given me the answer on this type of problem. Maybe what I am reading doesn't cover that, so if you are talking about a particular document, let me know and I will look at that. > From: "Chris Barnes" <[EMAIL PROTECTED]> > Date: Mon, 24 Jun 2002 05:03:53 +1000 > To: "Php-Db \(E-mail\)" <[EMAIL PROTECTED]> > Subject: RE: [PHP-DB] Question > > 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 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php