ted hart
|
Posted: 09/08/2003, 10:15 AM |
|
Knowing that we have one table for security & 3 tables for jobs, employment
ads, and one for freelancers.
People have to register (security table) to be able to fill a profile/ad
(jobs - opportunities & freelancers) Use is related to security table
(right?) so how can I get a user that registered as a freelancer update his
profile ONLY (and not other users profiles) in freelancers table (security
and group levels allows them to update/edit any record in table).
UserId is the autoincrement field in table "members" which is the security
table. WHERE condition is where id = id or userid = id.
In other tables (Jobseekers, Job Ads, or freelancers ) id (autoincrement is
generated when registered in members (security) table) I thought maybe I
have to pass the value from UserId (members table) to another field in
information table (jobseekers for example) to allow update of the record the
registered user created only.
Thanks for your help
|
|
|
|