to get the role of the user

[musham]

i want to get the ROLE of an user by entering the username and password in login form....
for example::
username password role
ramesh xxxxxxx manager

loginform::
enter username:
enter password:
plllllzzzzz any one post the required query of the above problem

[peter_budo]

How are we supposed to help you if we do not know your tales structures?

[debasisdas]

if everything is stored in databaase tables then simply run a search using where clause and by passing the username and password.