The right SQL syntax would be:

UPDATE $table SET type='$type', year='$year' WHERE id='$id';

Svar - ICELAND



-----Original Message-----
From: Matt Hedges [mailto:[EMAIL PROTECTED] 
Sent: 19. jn 2003 23:07
To: [EMAIL PROTECTED]
Subject: [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
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.

Is there anyway to where if it reads a blank field instead of deleting
the
old information, the update php file just leaves it the same?


thanks very much for any help,
Matt Hedges





-- 
___________________________
| Matt Hedges
| http://hedgesinnovations.com
|



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to