password() ???

[jsscart]

How the hell does this function work?
I can get the md5() to work but not this one.
here's my code:
$query=("insert into user (id,username,password) values ('','$frmuser','PASSWORD('$frmpass')')");

and here's my error:

ERROR - You have an error in your SQL syntax near 'asd')')' at line 1
this is the password section.
I've tried double and no quotes still get no good results. I've looked at the mysql site and the php site and couldn't find info on this function. Please help

thanks all

[glansing]

<PRE>
$query = "INSERT INTO user (id, username, password) VALUES ('', $frmuser, PASSWORD($frmpass))";
</PRE>
try that...
-g

[jsscart]

I tried and it was close I just had to add single quote around value variables:
VALUES ('','$frmuser',PASSWORD('$frmpass'))

without them it said there was no field named $frmuser (the name entered not the string) in table field list

that worked perfectly

Thanks alot