PHP and MySQL Inserting stuff help

Darkness22k

This is my code:

$sql = "INSERT INTO `name` ( `name` ) "
        . "VALUES ("$_POST["membername"]");"
        . "";
mysql_query($sql);

I have a form where the person fills out their username and then it sends it to the DB. But for some reason it says the username is "$_POST["membername"]" and not what they filled out. Help?

LordShryku

Single quotes. And less double quotes. No need to seperate all that. No need for the extra semicolon...

$sql = "INSERT INTO `name` ( `name` )
        VALUES ('".$_POST["membername"]."')";
mysql_query($sql);

Darkness22k

Just tried it. Thanks! 🙂

LordShryku

yarr! 😃

tbone

Too many "s

Try . "VALUES ("$_POST['membername']");"

or . "VALUES ('$_POST[membername]');"

LordShryku

Hey tbone....those won't work. You have to seperate your superglobals from the string with either .'s or {}'s.