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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php