brianj1398
Posts: 1
|
| Posted: 06/23/2005, 7:37 AM |
|
I am working on a student registration system, and I have a table called course, and their is a realtionship with the following tables using the course id: staff, students, attendance, and staff attendance tables. Is there a way that I can filter records in the above tables, so that the user can only see their courses, staff, students, attendance, etc. ? I would also like the administrator to be able to see everything.
_________________
Brian Jackson |
 |
 |
Oper
Posts: 1195
|
| Posted: 06/23/2005, 11:00 AM |
|
id = ccgetuserid()
http://www.GlobalDevelop.com
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
Oper
Posts: 1195
|
| Posted: 06/30/2005, 9:21 AM |
|
Got your PM.
For Admin too.
Use for the user:
IDfield = ccgetuserid()
You Shoudl have a Query created where you have the user Table linked to get the GroupLevel.
then Should be:
IDfield = ccgetuserid() OR
usertable.Level >= 90
if 90 is Admin Level.
Let me know if worked.
http://www.GlobalDevelop.com
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
|
