stupid mysql error

[scrupul0us]

can someone figure this out:

if(isset($_GET['action']) && $_GET['action'] =="add")
{
$query = "INSERT INTO `guests` (`gID`, `gFNAME`, `gLNAME`, `gADDY1`, `gADDY2`, `gCITY`, `gSTATE`, `gZIP`, `gTEL`, `gEMAIL`, `gCOUNT`, `gRSVP`, `gATTEND`) VALUES (\'\', \'$_POST['fname']\', \'$_POST['lname']\', \'$_POST['addy']\', \'$_POST['count']\', \'$_POST['city']\', \'$_POST['state']\', \'$_POST['zip']\', \'$_POST['phone']\', \'$_POST['email']\', \'$_POST['count']\', \'$_POST['rsvp']\', \'$_POST['attend']\');" or die(mysql_error());
}

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /var/www/htdocs/thesites/wedding/index.php on line 41

Where line 41 is the line $query is on...

Heres what I'm posting:

Array ( [fname] => First Name [lname] => Last Name [count] => 1 [addy] => Address [rsvpd] => 0 [city] => City [state] => NY [zip] => 12305 [attend] => 0 [phone] => 555-555-5555 [email] => [e-mail] [Submit] => Submit )

thanks!

[Houdini]

The best way of dealing with a query like this is to create short variables first like so. Also there is no need to escape single quotes within a query that is enclosed in double quotes.

<?php
//create short variables
$fname=$_POST['fname'];
$lname=$_POST['lname'];
$addy=$_POST['addy'];
$count=$_POST['count'];
$city=$_POST['city'];
$state=$_POST['state'];
$zip=$_POST['zip'];
$email=$_POST['email'];
$phone=$_POST['phone'];
$rsvp=$_POST['rsvp'];
$attend=$_POST['attend'];
//now create the query
$query = "INSERT INTO `guests` (`gID`, `gFNAME`, `gLNAME`, `gADDY1`, `gADDY2`, `gCITY`, `gSTATE`, `gZIP`, `gTEL`, `gEMAIL`, `gCOUNT`, 
`gRSVP`, `gATTEND`) VALUES('','$fname','$lname','$addy','$count','$city','$state','$zip','$phone','$email'
,'$count','$rsvp','$attend')";

[scrupul0us]

that got it 🙂

if(isset($_GET['action']) && $_GET['action'] =="add")
{
	$fname=$_POST['fname'];
	$lname=$_POST['lname'];
	$addy=$_POST['addy'];
	$count=$_POST['count'];
	$city=$_POST['city'];
	$state=$_POST['state'];
	$zip=$_POST['zip'];
	$email=$_POST['email'];
	$phone=$_POST['phone'];
	$rsvp=$_POST['rsvp'];
	$attend=$_POST['attend'];

$result = mysql_query("INSERT INTO `guests` (`gID`, `gFNAME`, `gLNAME`, `gADDY1`, `gADDY2`, `gCITY`, `gSTATE`, `gZIP`, `gTEL`, `gEMAIL`, `gCOUNT`,
`gRSVP`, `gATTEND`) VALUES('','$fname','$lname','$addy','$count','$city','$state','$zip','$phone','$email'
,'$count','$rsvp','$attend')") or die(mysql_error());
	if (!$result) 
	{
	   die('Could not query:' . mysql_error());
	}
}