I'm trying to check if a file is being uploaded, and if so, run the first update query under my conditional submit area, however it's not picking up the empty or non-empty conditional upload field. So no matter if I have a file uploaded or not, it always runs the second update query below. Why?
if(isset($_GET['editarchive'])) {
//check for submit and if file upload field is filled
if ((isset($_POST['submit'])) && ($_FILES['images']['name'] != '')){
$root = str_replace('\\', '/', $_SERVER['DOCUMENT_ROOT']);
move_uploaded_file($_FILES["image"]["tmp_name"],
$root."/esufinal/images/archives/" . $_FILES["image"]["name"]);
//upload field is not empty, insert it into db
$query = "UPDATE archives SET date = '".$_POST['date']."', name = '".$_POST['name']."', body = '".$_POST['body']."', weburl = '".$_POST['weburl']."', image = '".$_FILES["image"]["name"]."', cat = '".$_POST['cat']."', preset = '' WHERE id='$_GET[editarchive]'";
mysql_query($query,$db);
} else {
//image already in place, skip upload of image and leave out of query
$query = "UPDATE archives SET date = '".$_POST['date']."', name = '".$_POST['name']."', body = '".$_POST['body']."', weburl = '".$_POST['weburl']."', cat = '".$_POST['cat']."', preset = '' WHERE id='$_GET[editarchive]'";
mysql_query($query,$db);
echo $query;
echo "<br><b><font color=D40000>Your entry was edited successfully.<br></font><br/></b><hr>";
}
//form code below
$query = "Select * FROM archives WHERE id='$_GET[editarchive]'";
$res=mysql_query($query) or die("SQL: $query<br />\nError: ".mysql_error());
$row=mysql_fetch_array($res);
echo "<form name=\"form\" method=\"post\" enctype=\"multipart/form-data\" action=\"archives.php?editarchive=$_GET[editarchive]\">";
echo "Date: <input type=\"text\" name=\"date\" value=\"$row[date]\"><br><br>";
echo "Name: <input type=\"text\" name=\"name\" value=\"$row[name]\"><br><br>";
echo "Web Url: <input type=\"text\" name=\"weburl\" value=\"$row[weburl]\"><br><br>";
echo "Area of Focus: ";
echo "<select name='areasoffocus'>";
$query4 = "SELECT * from class_categories ORDER BY 'CategoryName' ASC";
$mysqlresult4 = mysql_query($query4);
while($row4 = mysql_fetch_array($mysqlresult4)){
echo "<option value='$row4[CategoryID]' ";
if ($row4['CategoryID']==$row['CategoryName']){echo "selected";}
echo ">$row4[CategoryName]</option>";
}
echo '</select><br><br>';
//$root = str_replace('\\', '/', $_SERVER['DOCUMENT_ROOT']);
//$filename = "$root/esufinal/images/archives/$row[image]";
echo "<img src=\"../images/archives/$row[image]\"><br><br>";
echo "Upload Image: <input type=\"file\" name=\"image\" size=\"20\"><br><br>";
echo "Description: <br><textarea name=\"body\" cols=\"70\" rows=\"10\" class=\"tablecell2\">$row[body]</textarea><br><br>";
echo "<input type=\"submit\" name=\"submit\" value=\"Save Changes\"><input type=\"reset\" name=\"submit2\" value=\"Reset\"></form>";
}
