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 "
SYNERGY SALES REPORT
Vehicles releases thru Synergy"; echo "".$brand."
"; echo "MODEL | "; echo "YR.MODEL | "; echo "DESCRIPTION | "; echo "CS# | "; echo "COLOR | "; echo "RELEASED DATE | "; echo "RELEASED BY | "; echo "COMPANY | "; echo ""; while($row=mysql_fetch_array($getData)){ echo "
---|---|---|---|---|---|---|---|
".$row['brand_code']." | "; echo "".$row['year_model']." | "; echo "".$row['description']." | "; echo "".$row['cs_number']." | "; echo "".$row['color']." | "; echo "".$row['date_released']." | "; echo ""; $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" | "; echo "".$row['company']." | "; echo "
Date Prepared: ".date("m/d/Y")." ".date('h:i a')."
"; echo "