case 'submitprod2' : if (!isset($_POST['name'] || !isset($_POST['desc']) || !isset($_POST['category'])) //added !isset { echo 'You did not fill in a title!

Go back and try again.'; break; //if they're not set, using them will give you an error ^ } if( $_FILES['file']['tmp_name'] != "" ){ // Define the upload location $target_path = "../images/"; // Create the file name with path $target_path = $target_path . basename( $_FILES['file']['name']); // Try to move the file from the temporay directory to the defined. if(move_uploaded_file($_FILES['file']['tmp_name'], $target_path)) { echo "The file ". basename( $_FILES['file']['name']). " has been uploaded
"; } else{ echo "There was an error uploading the file, please try again!"; } $prod_img = $target_path.$_FILES['file']['name']; $_GET['id'] = (int)$_GET['id']; //force int on id, should check if this thing even exists $name = mysql_real_escape_string($_POST['name']);//consider the use of mysql_real_escape_string
$desc = mysql_real_escape_string($_POST['desc']); $category = $_POST['category']; //we're good, move on. $str = "UPDATE `products` SET `prod_name`='$name',`prod_desc`='$desc',`prod_cat_id`='$category',`prod_img`='$prod_img' WHERE `prod_id`=".($_GET['id'])." LIMIT 1"; //removed quotes around the integer field, and added a limit $qry = mysql_query($str) or die("There was an error submitting the query: " . mysql_error()); if ($qry) echo "Category edited successfully.
File modified successfully.
"; break;} else{ $_GET['id'] = (int)$_GET['id']; //force int on id, should check if this thing even exists $name = mysql_real_escape_string($_POST['name']);//consider the use of mysql_real_escape_string
$desc = mysql_real_escape_string($_POST['desc']); $category = $_POST['category']; $str = "UPDATE `products` SET `prod_name`='$name',`prod_desc`='$desc',`prod_cat_id`='$category', WHERE `prod_id`=".($_GET['id'])." LIMIT 1"; //removed quotes around the integer field, and added a limit $qry = mysql_query($str) or die("There was an error submitting the query: " . mysql_error()); if ($qry) echo "Category edited successfully.

"; break; }