Headhunter
|
| Posted: 12/28/2002, 11:35 AM |
|
CCS2 beta1 + PHP4 + Templates
Some explanation first:
In my project I collect all data from a pc (hardware, software, etc.).
I have for this 5 tables:
Table 1: PC: contains ID, modelID, customerID, template, Serial, (auto generated), manufacturerID, and some other stuff.
Table 2: SoftwarePC: contains ID, pcID, swrID, languageID, ...
Table 3: HardwarePC: conatins ID, pcID, hwrID, quantity, ....
and table software and hardware that contains all data from hard and soft.
Now, I use the template column (can be 0 or 1) to make the pc a reference pc, lets say a template.
What I want to do is make an exact copy (or more than 1) of this pc.
In table pc this is a single record, but in software and hardware this is most likely more than one record. So all related records from hardwarepc and software pc must be duplicated but with the new pcid. The problem is not how to do the hole database stuff but how to do it in CCS2. We (me and a friend of me) have done it in cc2, but now we want it to implement it clean in ccs2. (I am converting my whole project).
You may have a look at it at:
http://headhunter.dnsalias.org:14080/trackitstudio/login.php
(bear in mind that there are still bugs in it, and far from completion)
I made an admin login: login: guest and password: guest
Don't do anything I wouldn't do ;)
For those who realy want to help (and I appriciate that), mail me atbart.verstricht@pandora.be.
If you want, I can mail the code from cc2 that worked for me.
|
|
|
 |
Headhunter
|
| Posted: 12/30/2002, 3:27 PM |
|
Problem solved
|
|
|
|
|
