netk
|
Posted: 02/09/2001, 1:30 AM |
|
Hi there,
I've got a table called users with the following fields:
userid
userlogin
userpassword
username
usercountry
userlevel
then I've got a category table with:
categoryid
categoryname
categorycountry
with records as follows:
1. ART - 1
2. ART - 2
3. Sport - 1
4. Sport - 2
5. Love - 1
6. Love - 2
the 1 & 2 is refering to the country table where 1=UK and 2=Australia
I've created a page where you can edit the categories.
I then added a login screen for this categories edit page
and now I've got a problem . . . .
If the usercountry = 2, then the user should only be able to see the record
2, 4 and 6 of the categories table.
How do I do this ?
Do I create a sesion in the login page? If yes, how do I do this and how do
I read again in the categories edit page?
Please help
Albert Bredenhann
netK - Internet Knowledge Consultants
Tel : +27 82 924 6297
Fax: +27 82 131 924 6297
e-mail:albert@netk.co.za
website: www.netk.co.za
The information in this e-mail is confidential and is legally privileged. It
is intended solely for the addressee. Access to this e-mail by any one else
is unauthorised. If you are not the intended recipient, any disclosure,
copying, distribution or any action taken or omitted in reliance on it, is
prohibited and may be unlawful.
|
|
|
Alexey Alexapolsky
|
Posted: 02/09/2001, 4:35 AM |
|
Check SQL box and enter
select * from categories, users where categorycountry=usercountry
Add to Input parameter
userid/UserID/Session/Number/=/Required
--
Regards,
CodeCharge Support
netk <netk@freemail.absa.co.za> wrote in message
news:960daq$da2$1@news.codecharge.com...
> Hi there,
>
> I've got a table called users with the following fields:
>
> userid
> userlogin
> userpassword
> username
> usercountry
> userlevel
>
> then I've got a category table with:
>
> categoryid
> categoryname
> categorycountry
>
> with records as follows:
>
> 1. ART - 1
> 2. ART - 2
> 3. Sport - 1
> 4. Sport - 2
> 5. Love - 1
> 6. Love - 2
>
> the 1 & 2 is refering to the country table where 1=UK and 2=Australia
>
> I've created a page where you can edit the categories.
> I then added a login screen for this categories edit page
> and now I've got a problem . . . .
>
> If the usercountry = 2, then the user should only be able to see the
record
> 2, 4 and 6 of the categories table.
>
> How do I do this ?
>
> Do I create a sesion in the login page? If yes, how do I do this and how
do
> I read again in the categories edit page?
>
> Please help
>
>
> Albert Bredenhann
> netK - Internet Knowledge Consultants
>
> Tel : +27 82 924 6297
> Fax: +27 82 131 924 6297
> e-mail:albert@netk.co.za
> website: www.netk.co.za
>
> The information in this e-mail is confidential and is legally privileged.
It
> is intended solely for the addressee. Access to this e-mail by any one
else
> is unauthorised. If you are not the intended recipient, any disclosure,
> copying, distribution or any action taken or omitted in reliance on it, is
> prohibited and may be unlawful.
>
>
>
|
|
|
|