I have 3 variables.
When these variables are empty, I do NOT want their values written to the database (because they are empty).
I have written a series of IF statements that writes each value depending on if it has a value or not.
In my query statement, I do not reference the variables that are empty. For example $thumb1, $thumb2 and $thumb3 are the variables. When $thumb2 and $thumb3 are empty, it will grab the second if statement:
If ($thumb1 = ""){
$query = "UPDATE tblevents SET package1='$package1',package2='$package2',rate1='$rate1',rate2='$rate2',regularrate='$regularrate',
hours='$hours',description='$description'
WHERE name='$eventname'";
} else if ($thumb2 = "") {
$query = "UPDATE tblevents SET package1='$package1',package2='$package2',rate1='$rate1',rate2='$rate2',regularrate='$regularrate',
hours='$hours',description='$description',thumb1='$upfile'
WHERE name='$eventname'";
} else if ($thumb3 = ""){
$query = "UPDATE tblevents SET package1='$package1',package2='$package2',rate1='$rate1',rate2='$rate2',regularrate='$regularrate',
hours='$hours',description='$description',thumb1='$upfile',thumb2='$upfile2'
WHERE name='$eventname'";
}
If (!$thumb1 = "" && !$thumb2 = "" && !$thumb3 = ""){
$query = "UPDATE tblevents SET package1='$package1',package2='$package2',rate1='$rate1',rate2='$rate2',regularrate='$regularrate',
hours='$hours',description='$description',thumb1='$upfile',thumb2='$upfile2',thumb3='$upfile3'
WHERE name='$eventname'";
}
They all work properly, HOWEVER, in the database, the values in thumb2 and thumb 3 are erased, even when I don't write anything to these columns. Any ideas?
