On Thu, Mar 28, 2002 at 10:24:20AM +0700, Ady Wicaksono wrote:
> create temporary table tmpTableku select pw_passwd from vpopmail where
>pw_name='arman';
>
> Trus, untuk pengecekan - misal user memasukkan password "kakek"
> nah anda jalanin
>
> update tmpTableku set pw_passwd=encrypt('kakek');
>
> nah akhirtnya tinggal dibandingin semacam ini
>
>
> select a.pw_passwd, b.pw_passwd from vpopmail a, tmpTableku b where
> a.pw_passwd = b.pw_passwd and a.pw_name='arman';
lho .. kan simple saja:
select pw_name, pw_passwd from vpopmail where
pw_passwd=encrypt('kakek',pw_passwd);
Salam,
P.Y. Adi Prasaja
--
Utk berhenti langganan, kirim email ke [EMAIL PROTECTED]
Informasi arsip di http://www.linux.or.id/milis.php3
