[PHP] How to UPDATE only certain fields

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

Re: [PHP] How to UPDATE only certain fields

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

RE: [PHP] How to UPDATE only certain fields

The right SQL syntax would be: UPDATE $table SET type='$type', year='$year' WHERE id='$id'; Sævar - ICELAND -Original Message- From: Matt Hedges [mailto:[EMAIL PROTECTED] Sent: 19. júní 2003 23:07 To: [EMAIL PROTECTED] Subject: [PHP] How to UPDATE only certain fields Hello, I am