UPDATE syntax
| From: | Gerard Samuel | Date: | Mon, 13 Aug 2001 19:20:17 +0000 |
| Subject: | UPDATE syntax | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-62481@lists.php.net to get a copy of this message | ||
I have a database with 5 columns and cols 1,2,3 & 5 are filled. I want to insert into 4 and change 5. Could I use an UPDATE command to do this.. Here is what I have ==>
$query = "UPDATE mpn_asklee (Reply, Post) VALUES
('$Reply[$i]', '$post[$i]') WHERE ID = '$counts'";
$result = mysql_query($query);
If Im talking jibberish, let me know..