Gossamer Forum
Home : Products : Gossamer Links : Pre Sales :

SQL - Problem

Quote Reply
SQL - Problem
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



















Subject Author Views Date
Thread SQL - Problem Robert 3095 Jul 27, 2000, 4:21 PM
Thread Re: SQL - Problem
pugdog 3025 Jul 28, 2000, 11:56 AM
Post Re: SQL - Problem
Robert 3007 Jul 28, 2000, 4:22 PM