SELECT DECODE(ENCODE('password', 'sec'), SUBSTRING(secret,1,3));
if you put quotes around substring function, mysql considere it as a string,
so I think you shouldn't.
After, are you sure that the correct table field name is the weirdthing
encoded by this function : ENCODE('password', 'sec') ???
if so, show us, the script that allow you to record the password ?
- Original Message -
From: Donahue Ben [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, November 11, 2002 11:13 AM
Subject: [PHP] mysql DECODE question
SELECT DECODE(ENCODE('password', 'sec'), 'sec') -
password
When I try:
SELECT DECODE(ENCODE('password', 'sec'),
'SUBSTRING(secret,1,3)'); or without quotes around
SUBSTRING function
This does not produce the same output, i am not sure
what the problem is.
Ben
__
Do you Yahoo!?
U2 on LAUNCH - Exclusive greatest hits videos
http://launch.yahoo.com/u2
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php