0){
$i=1;
while ($obj_row = tep_db_fetch_array($recordset)) {
if ($obj_row["category_id"]==0) {
$cat_name = "General";
} else {
$cat_name = $obj_row["category_name"];
}
echo "";
echo "
| ".stripslashes($cat_name)." |
";
$query1 = "select * from banner
where banner.category_id='".$obj_row["category_id"]."' and
banner_status='Y' and is_approved='Y'
Order by display_order";
$recordset1 = tep_db_query($query1,$conn);
if (tep_db_num_rows($recordset1)>0){
$i=1;
while ($obj_row1 = tep_db_fetch_array($recordset1)) {
echo "
| |
|
";
}
}
echo "
| |
 |
";
echo " ";
}
}
?>
|
|