SQL Syntax

[ShoeLace1291]

I keep getting this error but I don't know why...

Parse error: syntax error, unexpected T_STRING in /home/mtechdev/public_html/freescripts/technews/install/insert_article.php on line 4

 

<?php

         $query = mysql_query("INSERT INTO tech_articles(authorID,headline,articleContent)
     values(1, "Welcome to TechNews!", "Congratulations!  You have completed the installation process and you may now start creating news articles!")") or die("Error: ".mysql_error());

?>

[cooldude832]

try putting the 1 in quotes

[akitchin]

it's because you're using " (double quote) to delimit the query, and then when you're defining your values, you use " to delimit them too.  that means you're cutting in and out of the query string.  change the double quotes around the values to single quotes.

[thefortrees]

If you want to use double quotes throughout the whole thing, you have to escape the " with \ so that when the code is parsed, the query string is interpreted as a whole, complete string. Or just use ' around the values instead of " like akitchin said.

 

Example:

$query = mysql_query("INSERT INTO tech_articles(authorID,headline,articleContent)
     values(1, \"Welcome to TechNews!\", \"Congratulations!  You have completed the installation process and you may now start creating news articles!\")") or die("Error: ".mysql_error());

 

OR

 

$query = mysql_query("INSERT INTO tech_articles(authorID,headline,articleContent)
     values(1, 'Welcome to TechNews!', 'Congratulations!  You have completed the installation process and you may now start creating news articles!')") or die("Error: ".mysql_error());