|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
July 12th, 2000, 07:10 PM
|
|||
|
|||
|
I seem to be having a bit of a difficulty,
I am try to do a match of a users form entered password. I've been trying this: SELECT * FROM users WHERE password=PASSWORD('$theirpassword'); naturally the $theirpassword is the users password. MySQL isn't returning a match.. when I know the password is entered correctly... any any any idea what/why? ------------------ SnR Graphics, Low Cost Hosting and Web Development.
|
|
#2
July 12th, 2000, 07:54 PM
|
|||
|
|||
|
<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by Robert_J_Sherman:
I seem to be having a bit of a difficulty, I am try to do a match of a users form entered password. I've been trying this: SELECT * FROM users WHERE password=PASSWORD('$theirpassword'); naturally the $theirpassword is the users password. MySQL isn't returning a match.. when I know the password is entered correctly... any any any idea what/why? [/quote] I've solved my own problem, it appears that I just didn't set my password field (in the database) to the right length.. guess I just didn't realize that the field needed to be something like VARCHAR(50) in order for the comparrisons to work out.. ------------------ SnR Graphics, Low Cost Hosting and Web Development.
|
|
| Viewing: Dev Shed Forums > Databases > MySQL Help > Matching PASSWORD() columns??? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
