Paul
|
Posted: 01/30/2002, 2:14 AM |
|
I have used a custom login to include a encrypted password in MySQL, each user is assigned with these fields: user_id (autonumber), user_name, password, division_country, ammend, approve. How can i display the values in the 'division_country', 'ammend' and 'approve' columns for this user only?
I think it should be something like this but i'm not sure.....
select division_country, ammend, approve
from users
where user_name = 'user_name_entered' and encode('password', 'seed') = user_password;
any ideas where i'm going wrong and where would this code go?
|
|
|
Alex Alexapolsky
|
Posted: 01/30/2002, 2:35 AM |
|
Do you what to hide these coulmns from other users at all or you
just want to show column data related to this user only ?
If all you need is filtering I suggest you using Gird/Form Properties/Input
tab where you can enter various filtering conditions.
|
|
|
Paul
|
Posted: 01/30/2002, 2:42 AM |
|
Alex
Ultimately I want to use 'division_country', 'ammend' and 'approve' as a security level for what each user is allowed to do... therefore i wanted to see just these records for the specific logged on user in order to then pass them onto another form.....
|
|
|
|