Image Edit Uploading Problem.

Hi, I'm creating a PHP/MySQL photo gallery app and I'm having problem with my "edit" page. I want the user to be able to change any of the fields in the record. In this case there are two text fields, and two "file" fields where they can browse to replace the images that are currently in the database. The "file" fields send a variable of "none" if the user doesn't change it. So, what I've done is created an if/else statement that says if these fields DON'T = "none", then do the SQL. However, I didn't account for the user just updating ONE of the image fields. Below is what I have so far: <?php if (($userfile_th) && ($userfile_full) && ($userfile_th && $userfile_full != "none")) { $db_name = "wonderland"; $table_name = "photo"; $connection = @mysql_connect("$db_loc","$db_user","$db_pass") or die("Couldn't Connect."); $db = @mysql_select_db($db_name, $connection) or die("Couldn't select database."); $sql ="UPDATE $table_name set title='$title',caption='$caption',thumbnail='$userfile_th_name',full_size='$ userfile_full_name' WHERE ID=\"$ID\""; $result = @mysql_query($sql, $connection) or die("Couldn't execute query."); copy($userfile_th, "/Users/emptyo/Sites/wonderland/images/gallery/thumbnail/$userfile_th_name") ; copy($userfile_full, "/Users/emptyo/Sites/wonderland/images/gallery/full_size/$userfile_full_name "); include("edit_photo_upd_suc.html"); } else { $db_name = "wonderland"; $table_name = "photo"; $connection = @mysql_connect("$db_loc","$db_user","$db_pass") or die("Couldn't Connect."); $db = @mysql_select_db($db_name, $connection) or die("Couldn't select database."); $sql ="UPDATE $table_name set title='$title',caption='$caption' WHERE ID=\"$ID\""; $result = @mysql_query($sql, $connection) or die("Couldn't execute query."); include("edit_photo_upd_ok.php"); } ?> So, my question is, do I need to do a separate if/else statement for every combination of what the user might want to change (Two text fields, and one image, or both images and no text fields, or 1 text field and 1 image, etc..) or is there a catch-all that might be able to do this for me? I'm a pretty new PHP'er, so forgive me if this is an obvious question, or there is a better way to do this. Please respond directly to mike@thinkmango.com as I am on the digest. TIA, mto -- Michael O'Neal Web Producer/ Autocrosser ST 28 '89 Civic Si --------------------- M A N G O B O U L D E R --------------------- http://www.thinkmango.com e- mike@thinkmango.com p- 303.442.1821 f- 303.938.8507