";
echo "
| PLATE |
BRAND |
MODEL |
JOB TYPE |
APPT. DATE |
APPT. TIME |
";
$result = mysql_query("SELECT * FROM vts_service_transaction WHERE `s_comp_code`='$sCompID' AND `s_deal_code`='$sDealID' AND `appt_date`='$searchDate' || `transferred_to`='$sDealID' AND `appt_date`='$searchDate' ORDER BY `appt_date` ASC");
while($row=mysql_fetch_array($result)){
$cBrand = mysql_result(mysql_query("SELECT `b_name` FROM `vts_brands` WHERE `b_id`='".$row['brand_id']."'"),0);
$Model = mysql_result(mysql_query("SELECT `m_name` FROM `vts_model` WHERE `m_id`='".$row['model_id']."'"),0);
$tSlot = mysql_result(mysql_query("SELECT `time_slot` FROM `vts_service_slots` WHERE `slot_id`='".$row['time_slot_code']."'"),0);
echo "";
echo "| ".$row['s_v_plate']." | ";
echo "".$cBrand." | ";
echo "".$Model." | ";
echo "".$row['s_appt_type']." | ";
echo "".$row['appt_date']." | ";
echo "".$tSlot." | ";
echo "
";
}
exit();
}
?>