INSERT INTO works fine but UPDATE returns errors

[gesseg]

Hi, Im getting a very odd result here. My code works fine and does what its supposed to when I use INSERT INTO (for my mysql table) but if i change that to UPDATE it breaks.

 

Heres the code:

<?php
$con = mysql_connect("host","user","pass");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("database", $con);

$sql="update table (counter, name)
VALUES
('$_POST[counter]','$_POST[name]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }

echo 'You entered the following votes:' . '<br />';
echo 'name ' . $_POST[name] . '<br />';
mysql_close($con)
?> 

 

Its really stumped me.

[kenrbnsn]

What error is returned?

 

Ken

[PFMaBiSmAd]

The syntax definition for an UPDATE query (with the most common usage in bold) -

 

UPDATE [LOW_PRIORITY] [iGNORE] table_reference

  SET col_name1={expr1|DEFAULT} [, col_name2={expr2|DEFAULT}] ...

    [WHERE where_condition]

    [ORDER BY ...]

    [LIMIT row_count]

 

 

[gesseg]

error is Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(counter, name, *a few other fields*' at line 1

 

Can you walk me through the bold bits of that PFMaBiSmAd?

 

Thanks.