trying to insert a MD5'ed variable into a MYSQL table but cant

[silverglade]

hi, my script is supposed to insert the word "password" as an MD5'ed string into my table. but it doesnt . here is my code, any help GREATLY appreciated as ive been working on this for a few hours. LOL. thank you. derek

 

 

<?php

include("connect1.php");


$1a = "password";
md5($1a);




mysql_query("INSERT INTO members (Email, Password)
VALUES ('user@yahoo.com','$1a')");


if(mysql_error())
{
echo "Error: " . mysql_error();
}
else
{
echo "Worked fine";
}

?>

[dgoosens]

md5($1a);

 

is the error...

this is not OOPHP but procedural...

 

thus, you should write it like this

$1a = md5($1a);

[silverglade]

great thank you very much. i changed it and the code is still not updating the table and not showing the "worked" message. here is the code im using now. any more help greatly appreciated thank you.

 

<?php

include("connect1.php");


$1a = "password";
$1a = md5($1a);




mysql_query("INSERT INTO members (Email, Password)
VALUES ('user@yahoo.com','$1a')");


if(mysql_error())
{
echo "Error: " . mysql_error();
}
else
{
echo "Worked fine";
}

?>

[dgoosens]

well, here again...

you should use a variable to get the response you're getting from mysql_query

 

do go through the doc and the examples here:

http://uk.php.net/manual/en/function.mysql-query.php

[Zane]

variable names can't start with a number.

[dgoosens]

variable names can't start with a number.

 

is it "1" (one) or "l" (L) ??

 

in code it is not very clear

$1a; // one
$la; // L

[silverglade]

thank you both SO MUCH!! i FINALLY got it to work! AWESOME HAHAHAHA. thank you very much. derek :D :D