Start Date: ". $newEdate; $getData = mysql_query("SELECT * FROM `db_vehicle_inventory` WHERE `sold`='1' AND `date_released` BETWEEN '$newSdate' AND '$newEdate' AND `company`='$filCompany' AND `released_by_comp` !='$filCompany' ORDER BY `date_released` ASC"); echo "
"; echo "
"; echo "
"; echo ""; echo "
"; echo "
"; echo "

SYNERGY SALES REPORT

Vehicles releases thru Synergy"; echo "

From: ".date('m/d/Y',strtotime($sDate))."-".date('m/d/Y',strtotime($eDate))."
"; echo "
"; echo "

".$brand."

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row=mysql_fetch_array($getData)){ echo ""; $releasedID = $row['released_by']; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
MODELYR.MODELDESCRIPTIONCS#COLORRELEASED DATERELEASED BYCOMPANY
".$row['brand_code']."".$row['year_model']."".$row['description']."".$row['cs_number']."".$row['color']."".$row['date_released'].""; $uFname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$releasedID'"),0); $uLname = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$releasedID'"),0); echo $uLname.", ". $uFname; echo"".$row['company']."
"; echo ""; echo "


Prepared by:_______________________
"; echo "

Date Prepared: ".date("m/d/Y")." ".date('h:i a')."

"; echo "
"; ?>