0){ echo ''; } if($sub){ $sql_count = mysql_query("SELECT count(`site_id`) from `sites` natural join `site_category` where `category_id`='$sub'"); $sql = mysql_query("SELECT title,ogg_votes,total_hits_out,`sites`.`site_id`, `ogg_votes` as `ogg_rank` FROM `site_category` natural join sites left join `ogg_sites` on `ogg_sites`.`site_id`=`sites`.`site_id` WHERE `category_id`='$sub' order by `ogg_rank` DESC, `total_hits_out` ASC limit $a,15"); } else{ $sql_count = mysql_query("SELECT count(`site_id`) from `sites` natural join `site_category` where `category_id`='$id'"); $sql = mysql_query("SELECT title,ogg_votes,total_hits_out,`sites`.`site_id`, `ogg_votes` as `ogg_rank` FROM `site_category` natural join sites left join `ogg_sites` on `ogg_sites`.`site_id`=`sites`.`site_id` WHERE `category_id`='$id' order by `ogg_rank` DESC, `total_hits_out` ASC limit $a,15"); } $count = mysql_fetch_array($sql_count); $total = $count[0]; $pages = ceil($total / 15); $id = clean($id); ?> 0){ while($i < $num){ $j = $i % 2; if($j == 1){ $trcolor = "#0044aa"; } else{ $trcolor = "#003399"; } $site_id = mysql_result($sql,$i,"site_id"); $stitle = mysql_result($sql,$i,"title"); echo ''; $k++; $i++; } ?> '; } ?> Online Games: 2D Games | 3D Games | Browser Games | Flash Games'; break; case "8": echo '2D Games | 3D Games | Browser Games | Flash Games'; break; case "49": echo '2D Games | 3D Games | Browser Games | Flash Games'; break; case "50": echo '2D Games | 3D Games | Browser Games | Flash Games'; break; } ?> '; while($si < $snum){ $sub_cat = mysql_result($sql_sub,$si,"category"); $sub_cat_id = mysql_result($sql_sub,$si,"category_id"); if($sub == $sub_cat_id){ echo $sub_cat; $ssub_cat = $sub_cat; } else{ echo ''.$sub_cat.''; } $gi = $si + 1; if($gi < $snum){ echo ' | '; } $si++; } echo ' Now listing '.$ssub_cat; } ?> ordered by MOST votes (1) & by least hits out (2) All time Votes In All time Hits Out '.$k.'.'.mysql_result($sql,$i,"title").' '.mysql_result($sql,$i,"ogg_votes").' '.mysql_result($sql,$i,"total_hits_out").' Pages: '.$j.''; } else{ echo ''.$j.''; } } $l = $j + 1; if($l <= $pages){ echo ' | '; } $j++; } ?> 1){ $j = $page - 1; if($sub){ echo '-Previous Page-'; } else{ echo '-Previous Page-'; } $pre = 'yes'; } if($page != $pages){ if($pre == "yes"){ echo ' | '; } $j = $page + 1; if($sub){ echo '-Next Page-'; } else{ echo '-Next Page-'; } } ?> There are no games in this category.

'; } ?>