0){ $i=1; while ($obj_row = tep_db_fetch_array($recordset)) { ?> "; } $i+=1; } } ?> 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 " "; $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 ""; } } ?>