gesseg Posted June 14, 2010 Share Posted June 14, 2010 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. Quote Link to comment Share on other sites More sharing options...
kenrbnsn Posted June 14, 2010 Share Posted June 14, 2010 What error is returned? Ken Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted June 14, 2010 Share Posted June 14, 2010 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] Quote Link to comment Share on other sites More sharing options...
gesseg Posted June 14, 2010 Author Share Posted June 14, 2010 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.