Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Adding member record after signup

Quote Reply
Adding member record after signup
Please see the introduction to this thread.

The directory already contains details of 1000+ companies. These will be given a user name and password. When they log in they should see a "modify company details" link. They should not see an "add company" link (1 company record per member, and the primary key is also the userid field).

When a new member signs up and logs in for the first time, they need to see a "add your company details" link, but not a "modify company details" link.

So when a member logs in, we need to know whether a record exists in the company table and display the appropriate link. So we need to run a query like

select comp_id from Company.

If the query returns a row, we display the modify link. If the query returns no rows, we display the add link.

Doesn't sound too bad. Can anyone explain how we do this in dbman sql 2 please?

When administrator logs in he should of course see all links.

many thanks
Tim Ault
Oxford UK
Subject Author Views Date
Thread Adding member record after signup timbo 2584 Sep 3, 2003, 3:02 AM
Post Re: [timbo] Adding member record after signup
ecamty 2489 Sep 3, 2003, 10:52 AM