query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getMansHead = "SELECT * FROM mancom_hdr WHERE `company_id`='$activeCompany' AND deleted = 0 AND `report_type`='$reportType' ORDER BY year DESC";
$qHeads = mysqli_query($conn,$getMansHead);
$qhRow = mysqli_num_rows($qHeads);
if($qhRow > 0){
while($rec = mysqli_fetch_array($qHeads)){
$linkData = "MANCOM_VehicleSalesReport.php?uid=$userID&c=".getCompanyNameSub($rec['company_id'])[1]."&d=".getDealerNameSub($rec['dealer_id'])[1]."&y=".$rec['year']."&token=0&hid=".$rec['id'];
?>".$rec['id']."";
echo "| ".$rec['year']." | ";
echo "".getCompanyNameSub($rec['company_id'])[1]." | ";
echo "".getDealerNameSub($rec['dealer_id'])[1]." | ";
echo "";
$update = explode(" ", $rec['last_update']);
$updateDate = $update[0];
echo $updateDate;
echo " | ";
echo "";
?>
";
echo " |
";
}
}else{
echo "No record found. |
";
}
$conn->close();
}
?>