parse error help

[census]

I keep getting this error:
Parse error: parse error, unexpected T_VARIABLE in <my file> on line 13

this is the block of code its erroring on.

line 13 is the "$query =" line

@mysql_select_db("glofkinator");
$passwd = md5($POST['pass']);
$query = "INSERT INTO users (uname, pass) VALUES('$POST[name]','$passwd')";
mysql_query($query);

its not a missing semicolon, and I know that the variable it errors on is the $passwd one, but I can print out $passwd without the $query line there so its not just a null/non-existant variable

any help would be much appreciated.

[ehask71]

Try

$query = "INSERT INTO users (uname, pass) VALUES('".$_POST[name]."','$passwd')";

OR

$query = "INSERT INTO users (uname, pass) VALUES('{$_POST[name]}','$passwd')";

I don't write queries like that anymore just from scaleability I lean towards

INSERT INTO users SET uname = '{$_POST['name']}', pass = '$passwd'

Also make sure you are sanitizing POST vars before inserting

Eric

[census]

The query you gave me worked to set each item instead of insert values

thank you very much