Advice needed
| From: | Mike Tuller | Date: | Sat, 13 Jul 2002 01:50:03 +0000 |
| Subject: | Advice needed | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-107457@lists.php.net to get a copy of this message | ||
I am trying to develop a front end to a database that will be used for entering information about
the computer systems I take care of. It would be easy to do if it weren't for one problem. I
want to list information about the drives that are in each system. There could be one, two, or 10
drives, so I want to have it generate a new table row for each drive. That I can do. The issue I run
into is how best to create the interface. Right now I have a page where everything is entered on one
page.
I have two tables in the database. One for the basic hardware information, and one for the volume
information. The volume table has a field for the hardwareID so that I can tie the volumes to the
hardware, and with a separte table, I can have as many drives as I want. The problem with this is
that when I click on a hyperlink to open a window for adding a volume, I need a hardwareID to be
able to tie the volume information to the hardware. The hardwareID is created in MySql when the
information entered for the hardware is submitted, which hasn't been done yet.
I could break this up into multiple pages, where I enter the basic information, and then I will have
an ID created to use so that I can add the volumes, but this could get messy. Is there a better way
of doing this?
This is confusing to follow, I know. Here is a link to the page I am talking about so that you can
get an idea of what I am talking about. http://bowser.homedns.org/assets/addasset.html
About 1/3 the way down, you will see an Add Volume link that will take you to the addvolume page.
Thanks in advance,
Mike