Another parsing error :(

southpaw3

The parsing error:

Parse error: parse error, unexpected '=' in /usr/home/ccamaj/public_html/mm/cmsadmin/editArticle.php on line 28

The snippet:

$insertQuery = "UPDATE cmsarticles SET 
title ="."'".$_POST['title']."', ".
author ="."'".$_POST['author']."', ".
image ="."'".$_POST['image']."', ".
summary ="."'".$_POST['summary']."', ".
section ="."'".$_POST['section']."', ".
thearticle ="."'".$_POST['thearticle']."' 
WHERE id='".$_POST['ID']."' LIMIT 1;";

When I take out the ='s, the code doesn't work... so I'm completely lost.

Again, thanks in advance for any help.

coreyp_1

2 ways to fix it:

$insertQuery = "UPDATE cmsarticles SET
title ="."'".$_POST['title']."',
author ="."'".$_POST['author']."',
image ="."'".$_POST['image']."',
summary ="."'".$_POST['summary']."',
section ="."'".$_POST['section']."',
thearticle ="."'".$_POST['thearticle']."'
WHERE id='".$_POST['ID']."' LIMIT 1;";

~ OR ~

$insertQuery = "UPDATE cmsarticles SET
title ="."'".$_POST['title']."', ".
"author ="."'".$_POST['author']."', ".
"image ="."'".$_POST['image']."', ".
"summary ="."'".$_POST['summary']."', ".
"section ="."'".$_POST['section']."', ".
"thearticle ="."'".$_POST['thearticle']."'
WHERE id='".$_POST['ID']."' LIMIT 1;";

using a code editor with syntax highlighting will help you catch some of these. I use PHP Designer 2005 myself.

Weedpacket

Also, PHP provides syntax-highlighting itself should you wish to have a look.
Here's the originally posted code using syntax highlighting (provided by &#91php] tags):

$insertQuery = "UPDATE cmsarticles SET 
title ="."'".$_POST['title']."', ".
author ="."'".$_POST['author']."', ".
image ="."'".$_POST['image']."', ".
summary ="."'".$_POST['summary']."', ".
section ="."'".$_POST['section']."', ".
thearticle ="."'".$_POST['thearticle']."' 
WHERE id='".$_POST['ID']."' LIMIT 1;";

And the problem becomes more visible.