Updating MySQL record

[Dag Eilertsen]

Hi!
I'm heaving a small problem updating a record containing an encrypted
password. I'm using aes_encrypt.

This is my suggestion for the query (that obviously doesn't work very well):

$sql_update = "UPDATE $Tabell SET
fornavn = \"$for_navn\",
etternavn = \"$etter_navn\",
brukernavn = \"$bruker_navn\",
passord = aes_encrypt(\"$pass_ord\")
WHERE brukerid=\"$id\"";

Can anybody help me with a query that will work?

Tnx
Dag Eilertsen

[Alvaro G Vicario]

*** Dag Eilertsen wrote/escribió (Mon, 30 Aug 2004 04:56:24 +0200):

> I'm heaving a small problem updating a record containing an encrypted
> password. I'm using aes_encrypt.

Have you checked whether AES_ENCRYPT() works in your MySQL server?

"AES_ENCRYPT() and AES_DECRYPT() were added in MySQL 4.0.2, and can be
considered the most cryptographically secure encryption functions currently
available in MySQL."



--
-- Álvaro G. Vicario - Burgos, Spain
-- Questions sent to my mailbox will be billed ;-)
--

[Virgil Green]

"Dag Eilertsen" <dag.erik.eilertsen@broadpark.no> wrote in message
news:41329855$1@news.broadpark.no...

> Hi!
> I'm heaving a small problem updating a record containing an encrypted
> password. I'm using aes_encrypt.
>
> This is my suggestion for the query (that obviously doesn't work very

well):

It's far from obvious to me.

> $sql_update = "UPDATE $Tabell SET
> fornavn = \"$for_navn\",
> etternavn = \"$etter_navn\",
> brukernavn = \"$bruker_navn\",
> passord = aes_encrypt(\"$pass_ord\")
> WHERE brukerid=\"$id\"";
>
> Can anybody help me with a query that will work?

In what way did this one fail?

- Virgil