Re: problem with multiple fields
| From: | Vinss | Date: | Thu, 19 May 2005 10:12:45 +0000 |
| Subject: | Re: problem with multiple fields | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-215577@lists.php.net to get a copy of this message | ||
but in fact for example:
pc reception have two memory module but i do the gestion of the individual
pieces too
for example in a table i have
id name ref hs?
1 sdram256 22055 True
2 sdrram512 22056 True
so i need to keep the informations of the reference too
2005/5/19, Tom Rogers <trogers@kwikin.com>:
>
> Hi,
>
> Thursday, May 19, 2005, 6:07:53 PM, you wrote:
> V> sorry for my poor english, i'll try to be understood
> V> so i want to represent an informatic parc but have a problem
> V> for example a pc can have 2 or more memory slot filled how to stock
> V> the different id in a list in my database and how extract it
> V> for the moment i just have an external key referencing one memory.
> V> Have you an idea to help me please?
>
> It is probably best to put the individual items in a separate table
> and link their keys, as an example with 3 tables
>
> table items
> itemid
> name
>
> table item_list
> pcid
> itemid
>
> table pc
> pcid
> location
>
> then these could contain
> items
> itemid name
> 1 memory module
> 2 floppy drive
>
> pc
> pcid location
> 1 reception
>
> item_list
> pcid itemid
> 1 1
> 1 1
> 1 2
>
> so reception pc contains 2 memory modules and 1 floppy
>
> Hope that helps
>
> --
> regards,
> Tom
>
>
--
Ne sois pas trop prompt en parole réfléchis
aux conséquences de tes mots.
Derrière un pc il y a toujours un humain