Parse Error

[foucquet]

Why does this :-

 

// Insert data into database
$insert = "INSERT INTO users(nick, password, email, sex, regdate) VALUES('$_POST['nick']', '$_POST['pwd']', '$_POST['email']', '$_POST['sex']', '$today')";

$add_member = mysql_query($insert);

 

give me this:-

 

Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in C:\wamp\www\php\test site\regproc.php on line 40

 

I know it is probably something to do with quotation marks, but having tried every combination that I can think of I still can't work it out...

[kickstart]

Hi

 

I am not keen on trying to use arrays in string like that so tend to just concatenate the array vars in like this

 

// Insert data into database
$insert = "INSERT INTO users(nick, password, email, sex, regdate) VALUES('".$_POST['nick']."', '".$_POST['pwd']."', '".$_POST['email']."', '".$_POST['sex']."', '$today')";

$add_member = mysql_query($insert); 

 

All the best

 

Keith

[foucquet]

Thanks Keith, that works perfectly, it was the only thing I didn't try as I thought it was not possible to do this...