[RESOLVED] String Trouble

[middleman666]

hey people,

having a tad bit of trouble doing something that I thought was simple enough :S

$value = 'VALUE';
$sqlstartnote = 'INSERT INTO `CYRPromo` ( `id` , `Code` , `Active` ) VALUES (NULL , '';
$sqlendnote = '', '1');';

$SubmittedTable = "\n".$sqlstartnote.$value.$sqlendnote."\n";

Basically I just want to write a line of text to a txt file which says:
INSERT INTO CYRPromo ( id , Code , Active ) VALUES (NULL , 'VALUE, '1');

so I can use it later to fill in the database.

I get the error:
Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING
on the line:
$sqlendnote = '', '1');';

I can't spot what i'm doing wrong, can someone help me out?

Thanks

[middleman666]

no matter, got it know.

$sqlstartnote = 'INSERT INTO `CYRPromo` ( `id` , `Code` , `Active` ) VALUES (NULL , \''; 
$sqlendnote = '\', \'1\');'; 

[Houdini]

This will give your intended result but I am not too sure about the syntax ... oh well here you go

$sqlstartnote = "INSERT INTO `CYRPromo` ( `id` , `Code` , `Active` ) VALUES (NULL , '$value', '1');";