example
i have table account, conssist of username and password
in php:
to input
mysql_query("insert into account values ('mada',password('mada')) ");
to select
mysql_query("select * from account where username='mada' and password=password('mada') ");
hope it useful :D