Me and this syntax issue

[dlyles]

I swear I'm going to get this together and eliminate the need for simple post.  In the meantime, can someone tell me what's wrong with this?

[code]
$mygroup=$_COOKIE['group'];
$partname=mysql_real_escape_string($_POST['partname']);
$newquery="select * from parts where PartName = '" . $partname . "'";
$newresult=mysql_query($newquery);
$balance = $row['balance'] - mysql_real_escape_string($_POST['amountreceived'])';


$sql = "insert into parts (GroupID, ModelID, PartName, Cost, balance)
          VALUES ('" . $mygroup .
                      "', '" . $mymodel .
                      "', '" . mysql_real_escape_string($_POST['partname']) .
                      "', '" . mysql_real_escape_string($_POST['cost']) .
                      "', '" . $balance . "')";
$nresult = mysql_query($nsql) or die("Error 2: query: $nsql<br>" . mysql_error());
[/code]
the error is in the $mygroup value.

[kenrbnsn]

What error are you getting?

Ken

[dlyles]

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /var/opt/data/rgbdata/apache/htdocs/receiveaction.php on line 24

Line 24 is
[code]
    VALUES ('" . $mygroup .
[/code]

[craygo]

wight want to try it like this
[code] $sql = "insert into parts (GroupID, ModelID, PartName, Cost, balance)
          VALUES ('".$mygroup."',
                      '".$mymodel."',
                      '".mysql_real_escape_string($_POST['partname'])."',
                      '".mysql_real_escape_string($_POST['cost'])."',
                      '".$balance."')";[/code]

Same think but why would you enter right in the middle of the insert??

[dlyles]

Same error :(

[craygo]

echo your sql statement and see if $mygroup is there

[code] $sql = "insert into parts (GroupID, ModelID, PartName, Cost, balance)
          VALUES ('" . $mygroup .
                      "', '" . $mymodel .
                      "', '" . mysql_real_escape_string($_POST['partname']) .
                      "', '" . mysql_real_escape_string($_POST['cost']) .
                      "', '" . $balance . "')";

echo $sql;
// $nresult = mysql_query($nsql) or die("Error 2: query: $nsql<br>" . mysql_error());[/code]

Ray

[dlyles]

Thanks.