[RESOLVED] Parse Error

[Pream]

Can someone please help me this is hurting my head, I Cant figure this error out:

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/accordd1/public_html/artblock/regfix.php on line 72


here is a piece of code:

if ( $query == true && $query0 == true)
	{
		mysql_query("INSERT INTO 'FREE USER' ('UserID', 'E-mail', 'Password', 'Region', 'Gender', 'AGE','Newsletter') 	   	
		  VALUES
		('0','$_POST['email']','$_POST['password']','$_POST['country']', '$_POST['gender']','$_POST['age']','$_POST['subscribe']')");
	
	}

line 72:

('0','$_POST['email']','$_POST['password']','$_POST['country']', '$_POST['gender']','$_POST['age']','$_POST['subscribe']')");

your help will be greatly appreciated

[NogDog]

Use curly brace "complex" notation for your array elements within the double-quoted string, or else use concatenation.

// complex notation:
$string = "This is a {$array['sample']} string";
// concatenation:
$string = "This is a " . $array['sample'] . " string"; 

The other alternative is to remove the quotes from around the array indexes, due to a quirk in the PHP parser. However, I prefer not to do that as it is a bad habit to get into. (See the section entitled "Why is $foo[bar] wrong?" on this page.)

[Pream]

they werent meant to be array indexes, its a record into mysql adn query and query 0 are just 2 boolean vars i set earlier in the script

[NogDog]

$_POST is an array, and in $_POST['email'], 'email' is an index to that array.

mysql_query("INSERT INTO 'FREE USER' ('UserID', 'E-mail', 'Password', 'Region', 'Gender', 'AGE','Newsletter')            
   VALUES ('0', '{$_POST['email']}', '{$_POST['password']}', '{$_POST['country']}', '{$_POST['gender']}', '{$_POST['age']}', '{$_POST['subscribe']}')"); 

However, ultimately, this syntax problem is a minor issue compared to the fact that your code is wide open to SQL injection attacks. See www.php.net/mysql_real_escape_string for more info, as well as http://xkcd.com/327/.

[Pream]

thanks a lot