This feature would be best designed within the Users table...basically adding a ENUM (binary) field called ShowMyLinks (Yes/No). Then users can update their "profile" rather than going into another web form to update the "MyLinks" table, which should be an intersection table between the Links and Users table (meaning minimal that it should contain a concatment key of foreign keys from the Links and Users table, like the following example:
UserID (Primary - Not Unique)
LinkID (Index - Not Unique)
).
Then you could write a plug-in for "User" information that will show "My Links" for each user based on the ShowMyLinks column in the Users table. If YES, then query the MyLinks table to show all the Users links. If NO, then don't query the MyLinks table and print an error message...
Fairly easy to add-on...
Regards,
Eliot Lee
UserID (Primary - Not Unique)
LinkID (Index - Not Unique)
).
Then you could write a plug-in for "User" information that will show "My Links" for each user based on the ShowMyLinks column in the Users table. If YES, then query the MyLinks table to show all the Users links. If NO, then don't query the MyLinks table and print an error message...
Fairly easy to add-on...
Regards,
Eliot Lee