Hi all,
i have the following thing to solve:
I have 5 secure areas for every link(owner); i use links as a registry-database.
So i have 5 new fields name sec1-5;
Example:
No my problem:
With time the secure areas will grow, but i think its not the right thing always add a new field, my links has 60 fields now and i think this would be sometime too much for the system.
So how is it possible to save more than one values in one field???
Must i do for every ID a new table? or could i do something like:
TableID (autoinc) | LinkID | Value
0 | 1 | 2
1 | 1 | 4
means two entrees for linkID 1, so i can give access to area 2 and 4
Another table could store the (html)links for the areas
TableID | HTML-Link | Description
0 | http://www.... | This is secure area one
Hmm, seems good so far, but how to programm it :-(
Could anyone help?
Robert
i have the following thing to solve:
I have 5 secure areas for every link(owner); i use links as a registry-database.
So i have 5 new fields name sec1-5;
Example:
No my problem:
With time the secure areas will grow, but i think its not the right thing always add a new field, my links has 60 fields now and i think this would be sometime too much for the system.
So how is it possible to save more than one values in one field???
Must i do for every ID a new table? or could i do something like:
TableID (autoinc) | LinkID | Value
0 | 1 | 2
1 | 1 | 4
means two entrees for linkID 1, so i can give access to area 2 and 4
Another table could store the (html)links for the areas
TableID | HTML-Link | Description
0 | http://www.... | This is secure area one
Hmm, seems good so far, but how to programm it :-(
Could anyone help?
Robert