format("Y-m-d"); $brandID = mysql_result(mysql_query("SELECT `b_id` FROM `vts_brands` WHERE `b_name`='$brandName'"),0); $getUnitDescription=mysql_query("SELECT * FROM `vts_model` WHERE `b_id`= '$brandID' ORDER BY `m_name` ASC"); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row=mysql_fetch_array($getUnitDescription)){ $count = $count + 1; ?>".$count.""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

NO.	REF# ID	MODEL	MODEL PICTURE (180x100)	PRODUCT CATALOG (PDF Format)
".$row['m_id']."	".$row['m_name']."	"; if($row['image']==""){ echo "Upload Image"; }else{ echo "".$row['image'].""; } echo"	"; if($row['catalog_link']==""){ echo "Upload Product Catalog"; }else{ echo "".$row['catalog_link'].""; } echo"

"; ?>