PHP help

[dude8604]

I'm having a problem with this one line of my php script...

mysql_query("INSERT INTO pc VALUES("Grand Theft Auto 3","Action","Take-Two Interactive", "2002-05-22")");

and the error I get is

Parse error: parse error, unexpected T_STRING in c:\program files\apache group\apache\htdocs\setuprelease.php on line 30

Anyone know what's wrong with this? I have no idea. The database table "pc" exists, and has 4 fields like that, and I don't know what else it could be. Thanks.

 

[JW310]

I was running into a similar error when playing around with PHP and MySQL on my server.... I think it turned out to be a mismatched single quote or double quote (' or "), or I forgot to put in a semicolon (don't remember which offhand)... First thing I would do is check the lines before that one and make sure all the quote marks are lined up, and make sure you have the appropriate semicolons.

Thanks for the help in my PHP thread!

JW

 

[jpprod]

Yes, JW310 is right, change the line to...
mysql_query("INSERT INTO pc VALUES('Grand Theft Auto 3','Action','Take-Two Interactive', '2002-05-22')");
...and it'll work.

 

[kt]

it's also the fact that he has a double quote inside a double quote. the second double quote should be escaped.

 

[CanOWorms]

When I was learning PHP, I used to ask all sorts of questions and always get help at http://www.phpbuilder.com/

It was a great site back then, don't know if it's still good!