=$numentries) { $nav.='<< '; } else { $nav.='<< '; } while($row=mysqli_fetch_array($result)) { if($f>=$page-3*$numentries && $f<=$page+7*$numentries) { if($f%$numentries==0 && $currentpage != $g) { $nav.='' . $g . ' '; } else if($currentpage==$g) { $nav.=$currentpage . ' '; } } $d=$d+1; $g=1+$d/$numentries; $f++; } if($page<=$num_rows-$numentries) { $nav.='>> '; } else { $nav.='>> '; } $query='SELECT * FROM companies WHERE type="A" and category_id='.$id.' ORDER BY ' . $sort . ' ' . $order . ' limit ' . $page . ', ' . $numentries; $result=mysqli_query($db, $query) or die('Could not get subscribers'); $table = "level".$level."_categories"; $qz1 = mysql_query("select * from level1_categories WHERE id=".$id); $row1=mysql_fetch_array($qz1); echo '

'.$row1['category_name'].'

'; echo ''; $j=0; $curdate=date("Y-m-d"); while($row=mysqli_fetch_array($result)) { if($row['ExpiryDate']=='0000-00-00') { $exp_date=''; } else { $exp_date=$row['ExpiryDate']; } if($exp_date>=$curdate or $exp_date=='') { if($j%2==0) $style='class="grey"'; else $style='class="white"'; echo ''; } } echo '
LogoNamePhoneEmailWebsite
 '; if($row['type'] == 'C') $url = 'detailC.php?company_id='.$row['company_id'].'&cat_id='.$id.'&level='.$level.'&parent='.$parent; else if($row['type'] == 'B') $url = 'detailB.php?company_id='.$row['company_id'].'&cat_id='.$id.'&level='.$level.'&parent='.$parent; else if($row['type'] == 'D' or $row['type'] == 'E') $url = 'detailD.php?company_id='.$row['company_id'].'&cat_id='.$id.'&level='.$level.'&parent='.$parent; else if($row['type'] == 'A') $url = 'detailA.php?company_id='.$row['company_id'].'&cat_id='.$id.'&level='.$level.'&parent='.$parent; else if($row['type'] == '1') $url = 'detail.php?company_id='.$row['company_id'].'&cat_id='.$id.'&level='.$level.'&parent='.$parent; if($row['CompanyLogo'] != '') echo ''; echo ' ' . $row['name'] . ' ' . $row['PhoneNo1'] . ' '; if($row['EmailAddress1'] != '') echo ''.$row['EmailAddress1'].''; echo ' '; if($row['WebsiteAddress'] != '') echo ''.$row['WebsiteAddress'].''; echo '
'; /*echo '
NOTE: Refresh page after confirming subscribers - Refresh
';*/ echo '
' . $nav . '
 
'; ?>