RE: [PHP] UPDATE syntax
| From: | Don Read | Date: | Mon, 13 Aug 2001 19:27:32 +0000 |
| Subject: | RE: [PHP] UPDATE syntax | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-62484@lists.php.net to get a copy of this message | ||
On 13-Aug-2001 Gerard Samuel wrote:
> 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);
>
UPDATE mpn_asklee SET Reply='$Reply[$i]', Post='$post[$i]' WHERE ...
Regards,
--
Don Read dread@texas.net
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.