Hi,
I gave it a try and still the same syntax error. I can't see where
there is a problem. Could it be the way the table is created in the
database? I even made a test table with only the id and password and
still got the error. Here's what it looks like for the insert and
select statements.
INSERT INTO test VALUES ('555',AES_ENCRYPT('123456789','fff'))
SELECT `pid`, AES_DECRYPT(`passnum`, 'fff') AS `passnumdec` FROM
`test` WHERE `pid` = '555'
No luck. What am I missing?!
Thanks,
Mark
On May 25, 2007, at 2:22 AM, Tiago Relvão wrote:
> Your query seems OK, but it might be your password field. Maybe you
> have to
> use ``
>
> SELECT AES_DECRYPT(`password`, 'fff') AS `password_dec` FROM
> `table_name`
> WHERE `user_id` = '555'
>
> just a guess anyway... Tiago
>
> On 5/25/07, Mark Wheeler <[EMAIL PROTECTED]> wrote:
>>
>> Hi,
>>
>> I'm beating my head against a wall here. I can not figure out where
>> the syntax error is! Can anyone give me a helpful hint, please?
>> Here's how I encrypted it and how I am trying to decrypt it.
>>
>> INSERT INTO table_name VALUES ('555',AES_ENCRYPT('abcdefg', 'fff'))
>>
>> SELECT AES_DECRYPT(password, 'fff') AS password_dec FROM table_name
>> WHERE user_id = 555
>>
>> I don't get an error when inserting (or updating) but when I try to
>> decrypt, I get a syntax error. Where is it?
>>
>> Thanks very much for any help,
>>
>> Mark
>>
>>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> The php_mysql group is dedicated to learn more about the PHP/MySQL
> web database possibilities through group learning.
> Yahoo! Groups Links
>
>
>
