\n"; $ccheck = ''; $check = ''; //List links at top of page while($row = mysql_fetch_object($rq)){ if($ccheck != $row->countryname){ echo ''.$row->countryname.": \n"; $ccheck = $row->countryname; } if($check != $row->countyname){ echo 'county.'>'.$row->countyname." | \n"; $check = $row->countyname; } } mysql_data_seek($rq, 0); echo"
We have reviews on these categories
"; while($row = mysql_fetch_object($t)){ $count = 0; while ($cc = mysql_fetch_object($rq)){ if($cc->EstType == $row->id){$count++;} } mysql_data_seek($rq, 0); echo"$row->type($count) | "; } $shopnum = ''; $sportnum = ''; $eventnum = ''; while($row = mysql_fetch_object($oth)){ if($row->type == 'Shops'){$shopnum ++;} elseif($row->type == 'Sports'){$sportnum ++;} elseif($row->type == 'Events'){$eventnum ++;} } if(!empty($shopnum)){echo" Shops($shopnum)";} if(!empty($sportnum)){echo" | Sports($sportnum)";} if(!empty($eventnum)){echo" | Events($eventnum)";} include'dailyfeature.php'; ?>