How do I keep my form updates from overwriting data?

[amykhar]

Two ways to do it:
1. Check the database to see if there is data there. If there is, and the form field pertaining to that data is empty, simply readd the existing data.

2. Better yet, check each form variable and ONLY update the form fields that have values. I am not suggesting doing 3 or 4 update queries. I am suggesting that you write your query so that it is dynamic.

For example:

if ($formnamefield)
{
   $nameupdate = "name = '" . addslashes($formnamefield) . "',"
}
else 
{
  $nameupdate = '';
}

This technique is used many times by Jelsoft. Just poke around in your source code for concrete examples.