PHP Forum

**marcus1060** · 03-17-2005, 01:29 AM

PHP Code:


			
<?

$handle = fopen("/home/noveisne/public_html/scripts/marcus.php", "r");

$db = mysql_connect("localhost", "noveisne_***","h***");

mysql_select_db("noveisne_smf1",$db);

$sql = "INSERT INTO "smf_messages" ("ID_MSG", "ID_TOPIC", "ID_BOARD", "posterTime", "ID_MEMBER", "subject", "posterName", "posterEmail", "posterIP", "smileysEnabled", "modifiedTime", "modifiedName", "body", "icon") VALUES ('''', ''2'', ''2'', ''0'', ''2'', ''Test'', ''test'', ''test'', ''127.0.0.1'', ''1'', ''0'', NULL, ''tesz'', ''xx'')";



  $result = mysql_query($sql);

  echo "Story Added!\n";

?>

I'm confused why does that give me

Code:

Parse error: parse error, unexpected T_STRING in /home/noveisne/public_html/cron.php on line 5

**Frank Rizzo** · 03-17-2005, 04:16 AM

It's your use of double quotes!

You are setting the $sql variable by using double quotes, and yet inside that variable you are using double quotes. This is breaking the $sql var

And check the string near the end. You have double quotes " at the beginning but at the end of the line you are using two single quotes to make it look like a double quote

'+' is showing as '' (run the cursors through each mark and you'll see what I mean).