Mixing php function in SELECT query

[belick]

I need to use my PHP function in the mysql query like:

 

 

SELECT Password FROM TABLE WHERE User = 'AnyUser' && '$_POST[PASS]' = checkcrypt(Password ) LIMIT 0,1

 

Any help?

[ryanlwh]

$sql = "SELECT Password FROM TABLE WHERE User = 'AnyUser' && '$_POST[PASS]' = '".checkcrypt(Password)."' LIMIT 0,1"; 

[belick]

I tried that, the problem is that I need to place the "Password" field from the database which is something like: SDFDS3532523rfqASdfsd3D23D3f223g3g and instatd its try to decrypt the word Password...

 

 

 

[ryanlwh]

i thought Password was coming from a php variable...

how did you store the password? MD5?

[belick]

kind of I have my own encryption function, if it was md5 so mysql would work fine, that's my problem... :-(

[ryanlwh]

if you encrypt the password before storing into the db, then you could use the syntax I gave you. If not, then you have to do that after you got the record from the query.