query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
?>
REC.ID
| COMP ID |
CODE |
DEALER NAME |
BRAND |
|
|
|
';
$getAreaList = "SELECT * FROM `vts_dealerships` WHERE deal_status ='1'";
$getArea = mysqli_query($conn,$getAreaList);
$statRow = mysqli_num_rows($getArea);
if($statRow > 0){
while($row = mysqli_fetch_array($getArea)){
$count = $count + 1;
?>".$row['deal_id']."";
echo "| ".$row['comp_id']." | ";
echo "".$row['deal_code']." | ";
echo "".$row['deal_name']." | ";
echo "";
$bID = $row['brand'];
echo getBrandName($bID)[0];
echo " | ";
echo "";?>
";
echo " |
| ";
echo "
| ";
echo "
";
}
}
echo "";
$conn->close();
}
?>