<table width="100%">
<tbody>
<tr class="spl_tr">
<td height="30" class="brdr spl_td">S.NO</td>
<td valign="middle" class="brdr spl_td">Super Category</td>
<td valign="middle" class="brdr spl_td">Category</td>
<td valign="middle" class="brdr spl_td">Sub Category</td>
<td valign="middle" class="brdr spl_td">Product Name</td>
<td valign="middle" class="brdr spl_td">List Price</td>
<td valign="middle" class="brdr spl_td">Discount(%)</td>
<td valign="middle" class="brdr spl_td">Selling Price</td>
<td valign="middle" class="brdr spl_td">Action</td>
</tr>
<?php
$special_price = getSpecialProduct($user_id);
if(count($special_price) > 0)
{
$k = 1;
foreach ($special_price as $Special_Product) {
$super_id = getsuper($Special_Product['sp_product_id']);
$cat_id = getcat($Special_Product['sp_product_id']);
$sub_id = getsub($Special_Product['sp_product_id']);
$super_name = getsuperN($super_id);
$cat_name = getcatN($cat_id);
$sub_name = getsubN($sub_id);
$special_id = $Special_Product['sp_id'];
$product_name = getorderProd($Special_Product['sp_product_id']);
$list_price = $Special_Product['sp_list_price'];
$discount_price = $Special_Product['sp_discount'];
$selling_price = $Special_Product['sp_special_price'];
<table width="100%" >
<tbody>
<tr style="background-color: #F9F2DE;border-bottom: 1px solid #FF7E00; color:#fff;">
<td align="center" bgcolor="#f68210" class="brdr">S.NO</td>
<td align="center" width="25%" valign="middle" bgcolor="#f68210" class="brdr">Super Category</td>
<td align="center" width="5%" valign="middle" bgcolor="#f68210" class="brdr">Category</td>
<td align="center" width="20%" valign="middle" bgcolor="#f68210" class="brdr">Sub Category</td>
<td align="center" width="20%" valign="middle" bgcolor="#f68210" class="brdr">Product Name</td>
<td align="center" width="15%" valign="middle" bgcolor="#f68210" class="brdr">List Price</td>
<td align="center" width="5%" valign="middle" bgcolor="#f68210" class="brdr">Discount(%)</td>
<td align="center" width="35%" valign="middle" bgcolor="#f68210" class="brdr">Selling Price</td>
<td align="center" width="" valign="middle" bgcolor="#f68210" class="brdr">Action</td>
</tr>
<?php
$special_price = getSpecialProduct($cumpony_id);
if (count($special_price) > 0) {
$k = 1;
foreach ($special_price as $Special_Product) {
$super_id = getsuper($Special_Product['sp_product_id']);
$cat_id = getcat($Special_Product['sp_product_id']);
$sub_id = getsub($Special_Product['sp_product_id']);
$super_name = getsuperN($super_id);
$cat_name = getcatN($cat_id);
$sub_name = getsubN($sub_id);
$special_id = $Special_Product['sp_id'];
$product_name = getorderProd($Special_Product['sp_product_id']);
$list_price = $Special_Product['sp_list_price'];
$discount_price = $Special_Product['sp_discount'];
$selling_price = $Special_Product['sp_special_price'];
?>
<table width="100%" >
<tbody>
<tr style="background-color: #F9F2DE;border-bottom: 1px solid #FF7E00; color:#fff;">
<td align="center" height="30" bgcolor="#f68210" class="brdr">S.NO</td>
<td align="center" valign="middle" bgcolor="#f68210" class="brdr">Super Category</td>
<td align="center" valign="middle" bgcolor="#f68210" class="brdr">Category</td>
<td align="center" valign="middle" bgcolor="#f68210" class="brdr">Sub Category</td>
<td align="center" valign="middle" bgcolor="#f68210" class="brdr">Product Name</td>
<td align="center" valign="middle" bgcolor="#f68210" class="brdr">List Price</td>
<td align="center" valign="middle" bgcolor="#f68210" class="brdr">Discount(%)</td>
<td align="center" valign="middle" bgcolor="#f68210" class="brdr">Selling Price</td>
<td align="center" valign="middle" bgcolor="#f68210" class="brdr">Action</td>
</tr>
<?php
$special_price = getSpecialProduct($company_id);
if (count($special_price) > 0) {
$k = 1;
foreach ($special_price as $Special_Product) {
$super_id = getsuper($Special_Product['sp_product_id']);
$cat_id = getcat($Special_Product['sp_product_id']);
$sub_id = getsub($Special_Product['sp_product_id']);
$super_name = getsuperN($super_id);
$cat_name = getcatN($cat_id);
$sub_name = getsubN($sub_id);
$special_id = $Special_Product['sp_id'];
$product_name = getorderProd($Special_Product['sp_product_id']);
$list_price = $Special_Product['sp_list_price'];
$discount_price = $Special_Product['sp_discount'];
$selling_price = $Special_Product['sp_special_price'];
?>
