" .$site_name. " is packed with ".number_format($total_jokes, 0, 0, ',')." (yes ".convert_number($total_jokes)."!) of the funniest jokes, foibles and musings in the world. Use the navigation above to browse, search or submit a joke and more. "; $temp = mysql_query("SELECT * FROM jokes where is_published = 1 and is_random = 1 and dateadded <= NOW() ORDER BY RAND() LIMIT 1"); if($temp) { echo ""; while($row = mysql_fetch_array($temp)) { echo ""; echo ""; } echo " Filed Under: ".$row[category_name]."   ".$row[joke]." "; echo " "; } echo "Extra! Extra!: "; $temp = mysql_query("SELECT * FROM jokes where is_published = 1 and dateadded <= NOW() ORDER BY dateadded DESC LIMIT 3"); if($temp) { echo ""; $tracker = $start+1; while($row = mysql_fetch_array($temp)) { echo ""; echo ""; $tracker++; } echo " ".$tracker.".    Filed Under: ".$row[category_name]."   ".trim(substr(stripslashes($row[joke]), 0, 120))."... more "; echo " "; } echo "Trending: "; $temp = mysql_query("SELECT * FROM jokes where is_published = 1 and dateadded <= NOW() ORDER BY views DESC LIMIT 5"); if($temp) { echo ""; $tracker = $start+1; while($row = mysql_fetch_array($temp)) { echo ""; echo ""; $tracker++; } echo " ".$tracker.".    Filed Under: ".$row[category_name]."   ".trim(substr(stripslashes($row[joke]), 0, 120))."... more "; echo " "; } echo "From the Editor's Desk: "; $temp = mysql_query("SELECT * FROM jokes where is_published = 1 and dateadded <= NOW() ORDER BY votestartotal DESC LIMIT 5"); if($temp) { echo ""; $tracker = $start+1; while($row = mysql_fetch_array($temp)) { echo ""; echo ""; $tracker++; } echo " ".$tracker.".    Filed Under: ".$row[category_name]."   ".trim(substr(stripslashes($row[joke]), 0, 120))."... more "; echo " "; } ?>