0 ){ echo 'Error: ' . $_FILES['file']['error'] . '
'; } else { $promoID = mysql_escape_string($_POST['promoID']); $fullPath = $promoID . '_' . $_FILES['file']['name']; if(move_uploaded_file($_FILES['file']['tmp_name'], 'uimages/newsfeed/' .$fullPath)) { echo "File Uploaded Successfully"; } } $imageLink = "https://www.autohub.ph/connect/uimages/newsfeed/".$fullPath; //mysql_query("INSERT INTO vts_profile_images (cust_id, file_path) VALUES('$customerID','$fullPath')"); mysql_query("UPDATE `promo_list` SET `image_link`='$imageLink' WHERE `id`='$promoID'"); $getDateAdded = mysql_result(mysql_query("SELECT `date_added` FROM `promo_list` WHERE `id`='$promoID'"),0); $promoDesc = mysql_result(mysql_query("SELECT `promo_desc` FROM `promo_list` WHERE `id`='$promoID'"),0); $promoBrand = mysql_result(mysql_query("SELECT `promo_brand` FROM `promo_list` WHERE `id`='$promoID'"),0); $imageLink = mysql_result(mysql_query("SELECT `image_link` FROM `promo_list` WHERE `id`='$promoID'"),0); $promoTitle = mysql_result(mysql_query("SELECT `promo_title` FROM `promo_list` WHERE `id`='$promoID'"),0); $imageLink = mysql_result(mysql_query("SELECT `image_link` FROM `promo_list` WHERE `id`='$promoID'"),0); mysql_query("INSERT INTO newsfeed (date_posted, title, image, description ) VALUES('{$getDateAdded}','{$promoTitle}','{$imageLink}','{$promoDesc}')"); ?>