[nycphp-talk] MySQL UPDATE
Ken Robinson
kenrbnsn at rbnsn.com
Tue Apr 5 16:13:14 EDT 2005
Quoting Aaron Fischer <agfische at email.smith.edu>:
[snip]
> an empty field or changes the field value. However, the problem occurs
> when a user wants to remove a value, resulting in the field holding no
> value. The form will post fine, but the field that contains no value
> will not update the database. The database field retains it's existing
> data.
>
Do you have code that only updates the field if it's not blank? If so, that's
your problem.
>
> Would appreciate any tips/pointers; please let me know if additional
> info would be helpful.
Posting the code that does the update would be helpful.
Have you tried echoing the update query that you generate to make sure
it looks
right?
Ken
More information about the talk
mailing list