format("Y/m/d"); error_reporting(0); if(isset($_POST['Display'])){ $UserCompanyName = mysql_real_escape_string($_POST['UserCompanyName']); $brandName = mysql_real_escape_string($_POST['brandName']); $MyUserID = mysql_real_escape_string($_POST['MyUserID']); $MyUserFName = mysql_real_escape_string($_POST['MyUserFName']); } // echo "My Company ".$myCompanyCode; ?>
UPLOAD PRICELIST -
PRICELIST TITLE
START DATE
END DATE
SHORT DESCRIPTION.
format("Y-m-d"); //echo $MyCurrentDate; $getUnitDescription=mysql_query("SELECT * FROM `vts_price_list` WHERE `brand_code`= '$brandName' AND `end_date` > '$MyCurrentDate' AND `uploaded_by`='$MyUserFName' ORDER BY date_added DESC"); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row=mysql_fetch_array($getUnitDescription)){ $count = $count + 1; ?>".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
NOADDED BYTITLESTART DATEEND DATEIMAGE LINK
".$row['uploaded_by']."".$row['title']."".$row['start_date']."".$row['end_date'].""; if($row['image_link']==""){ echo "Upload file"; }else{ echo "".$row['image_link'].""; } echo"
"; ?>