I am working on a relational database and want to only display links in fields to certain "types" of users.

I have a webpage that lists different signup links that will take a user to a form that they complete with a hidden "usertype" field in it. There are four different forms/usertypes: artist, buyer, agent, manager.

Once the account has been created and the user logs into their account I would like to only display certain information in the footer depending on the user's "usertype". Since this is a relational database and I have both a user.db and a item.db with only one footer.pl how will I be able to do this?

Any ideas would be much appreciated :)
Cher

Where are you storing the usertype?

Have you seen this thread:

Topic: Write to db from create account
pabloa July 04, 1999
Thread: http://gossamer-threads.com/p/001226.html

I'm assuming you are trying to do the same thing, but I have no idea where you are storing or calling the usertype from. Have you setup these usertypes as permission levels?

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/

I tried to view the thread but couldn't for some reason

Basically in my user form I have a hidden UserType designating whether the user is an artist,agent,buyer or manager. I want to use this UserType to designate what links in the footer that they will have permission to see. Kind of like the per_admin thing.

The reason I want to do this is because I don't want the same navigation links to appear for all UserTypes.
Cher

Here's the current url for that thread, found by searching by the username:


http://www.gossamer-threads.com/perl/gforum/gforum.cgi?post=57018

I really think you will need to setup the permission levels for the different groups to do what you want to accomplish. Have you looked at the 'add permission mod'?

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/