Hey All,
I'm trying to DECODE a string (USING MYSQL) and isert it to mysql database.
When i'm in the webpage for phpmyadmin utility and inside the table page, using the SQL Tab. and using the following INSERT:
INSERT INTO `usercake_users` (`User_ID`,`Password`) VALUES (111,ENCODE("b8e3-3adc846d70a8","key101"))
The results are OK !!!
and than using:
SELECT `User_ID` , DECODE( `Password` , "key101")
FROM `usercake_users`
WHERE 1
LIMIT 0 , 30
I can get the real STRING.
When i'm using php CODE to do that, the results are BAD! I'm unable to get the original string from the Database.
Please advice. Avi