Re: How to UPDATE only certain fields
| From: | Thorsten Körner | Date: | Thu, 19 Jun 2003 23:16:05 +0000 |
| Subject: | Re: How to UPDATE only certain fields | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-152256@lists.php.net to get a copy of this message | ||
Hi Matt
Am Freitag, 20. Juni 2003 01:06 schrieb Matt Hedges:
> Hello,
>
> I am building an database of wines. I have fields of stuff like year,
> grape, etc. However, I want to be able to go in and change something
> without having to retype every field. As I have it right now, I use the
> UPDATE where id=$id function. However, this changes EVERY field. For
> example, if I want to only change the grape field and leave everything else
> the same (so I thus leave those fields blank) it overwrites the others with
> a blank field.
UPDATE tablename SET grape = 'someNewGrape' WHERE id = '$id'
This updates only the grape-field and leaves everything else as is.
CU
Thorsten
--
Thorsten Körner http://www.123tkShop.org