--- Ramiro Varandas Jr <[EMAIL PROTECTED]>
wrote:
> I think that this question might be kinda of stupid
> for all of you but I
> couldn't find a good answer... When we use the MySQL
> internal function -
> Password('string') - MySQL inserts that string
> codified into the database, so
> that people that look for that doesn't know the real
> password. But i have a
> client that have a website and in the table of
> customers I'd like to use that
> function to make it more secure, but when I do that,
> I can't authenticate the
> user anymore, because if i write:
>
> SELECT user_id FROM user WHERE user_pass =
> 'my_var'
>
> It doesn't return me a user... but it's there,
> registered...
You do a user_pass=PASSWORD(user_pass_variable) , it
shud work fine.
Rgds,
Sunil
__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://http://taxes.yahoo.com/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
