I have been building an extensive dB with MySQL for a large Insurance
Company and am nearing the completion stage. I have build several PHP
forms to show the preliminary pages to the various groups who will be
using this dB.
I have created the sign-in page where each user has types in their ID
and PW. From then on each query uses those variables for credentials.
To avoid duplication, I would like to use the USER form from the MySQL
dB. Since that uses the Password("PW") function, I can't seem to get my
validation query to work properly. For example:
SELECT User,Password from user where (User=$ID AND Password=$PW);
Result: Empty Set.
SELECT User,Password from user where (User=$ID AND Password($PW));
Result: Will match User only, will accept ANY PW.
Does anyone know how to properly check off the PW from the User table in
the MySQL db?
Thanks,
Kevin
---------------------------------------------------------------------
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
