".UCWords($cat)." Category:
";
echo "All our jokes listing within the ".$cat." category are listed below. Click on any of the items to view the full joke.
";
?>
|
0) {
echo "";
$tracker = $start+1;
while($row = mysql_fetch_array($temp)) {
echo "| ".$tracker.". | Category: ".$row[category]." ![".$row[votestartotal]." stars](images/small-stars-".$row[votestartotal].".gif) |
";
echo " | ".trim(substr(stripslashes($row[joke]), 0, 120))."... more
|
";
$tracker++;
}
echo "
";
}
?>
$perpage) {
$start2 = $start - ($perpage * 2);
if($start2 < 0) $start2 = 0;
echo "
< Previous Page ";
}
if($start < $total) echo "
Next Page >";
?>
Choose Category:
";
echo "Choose from the category listing below to being browsing our jokes by category.
";
?>
|
";
$tracker = 0;
while($row = mysql_fetch_array($cats)) {
// get total
$total = mysql_query("SELECT COUNT(id) AS total FROM jokes WHERE category = '".$row[category]."'");
$jokes_total = mysql_result($total, 0, total);
if($tracker == 0) echo "";
echo "| - ".$row[category]." (".$jokes_total.") | ";
if($tracker == 1) {
echo "
";
$tracker = 0;
}
else $tracker++;
}
echo "
";
?>