Welcome to Dear Blank
4 order by aa_posts.datePosted desc ";
else if ($cat == 'worst') $qry = "select aa_user.userName,aa_posts.ID,aa_posts.dear,aa_posts.post,aa_posts.sincere,date_format(aa_posts.datePosted,'%M %D, %Y, %h:%i %p') from aa_user,aa_posts,aa_ratings where aa_ratings.postID =aa_posts.ID and aa_user.userID = aa_posts.userID group by aa_ratings.rating having avg(aa_ratings.rating) < 3 order by aa_posts.datePosted desc ";
else if ($cat == 'top') $qry = "select aa_user.userName,aa_posts.ID,aa_posts.dear,aa_posts.post,aa_posts.sincere,date_format(aa_posts.datePosted,'%M %D, %Y, %h:%i %p') from aa_user,aa_posts,aa_ratings where aa_ratings.postID = aa_posts.ID and aa_user.userID = aa_posts.userID group by aa_ratings.rating having avg(aa_ratings.rating) > 2 order by aa_posts.datePosted desc";
else if (isset($cat)) $qry = "select aa_user.userName,aa_posts.ID,aa_posts.dear,aa_posts.post,aa_posts.sincere,date_format(aa_posts.datePosted,'%M %D, %Y, %h:%i %p') from aa_user,aa_posts where aa_posts.category = '$cat' and aa_user.userID = aa_posts.userID order by aa_posts.datePosted desc";
$getsql = mysql_query($qry);
$numresults = mysql_num_rows($getsql);
$numperpage = '5';
$page = $_GET['page'];
if (!$page) $page = 0;
$numlinks = ceil($numresults/$numperpage);
$start = $page * $numperpage;
$qry = $qry." limit $start, $numperpage ";
$sql = mysql_query($qry);
$catitle = mysql_query("select catname from aa_categories where id = '$cat'");
$catrowtitle = mysql_fetch_array($catitle);
$pagetitle = $catrowtitle[0];
if ($cat == 'hot') $pagetitle = 'What\'s Hot';
if ($cat == 'worst') $pagetitle = 'Worst Rated';
if ($cat == 'top') $pagetitle = 'Top Rated';
?>
0) $url .= 'Previous '; for ($i=1;$i<=$numlinks;$i++) { $x = $i -1; $y = $x - 1; if ($page == $x) $url .= $i.' '; else $url .= ''.$i.' '; } $z = $page + 1; if ($page < $numlinks - 1) $url .= 'Next '; if ($numlinks > 1) echo $url; ?>
';
}
else
{
echo '
';
}
}
}
else
if (!$_SESSION['userid'])
{
for ($i=1;$i<=5;$i++)
{
if ($i <= $rat)
{
echo '
';
}
else
{
echo '';
}
}
}
echo '
';
?> ';
}
}
}
else
if (!$_SESSION['userid'])
{
for ($i=1;$i<=5;$i++)
{
if ($i <= $rat)
{
echo '';
}
else
{
echo '';
}
}
}
echo '0) $url .= 'Previous '; for ($i=1;$i<=$numlinks;$i++) { $x = $i -1; $y = $x - 1; if ($page == $x) $url .= $i.' '; else $url .= ''.$i.' '; } $z = $page + 1; if ($page < $numlinks - 1) $url .= 'Next '; if ($numlinks > 1) echo $url; ?>