NYCPHP Meetup

NYPHP.org

[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