Quote:
Originally Posted by 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:
Code:
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.
|
Amy,
thank you for your quick response. Are you available for PM for some one-on-one? I really need to get this thing working.
Mike