format("Y-m-d"); //echo $MyCurrentDate; $getUnitDescription=mysql_query("SELECT * FROM `promo_list` WHERE `promo_brand`= '$brandName' AND `promo_end` > '$MyCurrentDate' AND `added_by`='$MyUserID' ORDER BY date_added DESC"); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row=mysql_fetch_array($getUnitDescription)){ $count = $count + 1; ?>".$count.""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

NO	PROMO ID	TITLE	START DATE	END DATE	DISCOUNT	IMAGE LINK
".$row['id']."	".$row['promo_title']."	".$row['promo_start']."	".$row['promo_end']."	".$row['promo_discount']."	"; if($row['image_link']==""){ echo "Upload Image"; }else{ echo "".$row['image_link'].""; } echo"

"; ?>