CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 sessions ?

Print topic Send  topic

Author Message
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.
>
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.