help

[bigrossco]

I am wanting help to do the following:

I have some PHP and mysql know-how and want to change this code:

        $result = db_query("UPDATE {$db_prefix}members
                            SET shop_Flag = '{$_POST['flag']}'
                            WHERE ID_MEMBER = {$ID_MEMBER}",
                            __FILE__, __LINE__);

to be able to INSERT INTO a table i have made, i know that it would usaly be done as follows:

Code: [Select]

$result = db_query("INSERT INTO {$db_prefix}gifts {(member, gifts) VALUES ($_POST['user'], $_POST['gift'])");
but when i go to the page is shows error:

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/chatsuk/public_html/forum/Sources/shop/items/Flag.php on line 79

[Daniel15]

Something like this should work:

Code: [Select]

$result = db_query("INSERT INTO {$db_prefix}gifts (member, gifts) VALUES ('{$_POST['user']}', '{$_POST['gift']})");