i'm developing a backend in Asp.NET for Prestashop. I've a small problem: can't decode password ! Here the code
cmd.CommandText = "SELECT * FROM ps_employee WHERE email=@email AND passwd=MD5(@pwd) AND active=1"
As you can see, i'm using MYSQL MD5 function, but ... it not work.. Password is correct, i'm sure...