include("notwerk_setup.php"); $title = "Quotes"; html_begin($title, $title); include("/home/sites/site8/web/config_local.php"); include("/home/sites/site8/web/ADOdb/adodb.inc.php"); include("/home/sites/site8/web/global_funcs.php"); connectdb(); if($next == "") { $res = $db->Execute("SELECT * FROM ent_humor WHERE catagory='Quotes' ORDER BY title DESC LIMIT 0,10"); } elseif($next == "1") { $res = $db->Execute("SELECT * FROM ent_humor WHERE catagory='Quotes' ORDER BY title DESC LIMIT 10,10"); } elseif($next == "2") { $res = $db->Execute("SELECT * FROM ent_humor WHERE catagory='Quotes' ORDER BY title DESC LIMIT 20,10"); } elseif($next == "3") { $res = $db->Execute("SELECT * FROM ent_humor WHERE catagory='Quotes' ORDER BY title DESC LIMIT 30,10"); } elseif($next == "4") { $res = $db->Execute("SELECT * FROM ent_humor WHERE catagory='Quotes' ORDER BY title DESC LIMIT 40,10"); } elseif($next == "5") { $res = $db->Execute("SELECT * FROM ent_humor WHERE catagory='Quotes' ORDER BY title DESC LIMIT 50,10"); } elseif($next == "6") { $res = $db->Execute("SELECT * FROM ent_humor WHERE catagory='Quotes' ORDER BY title DESC LIMIT 60,10"); } elseif($next == "7") { $res = $db->Execute("SELECT * FROM ent_humor WHERE catagory='Quotes' ORDER BY title DESC LIMIT 70,10"); } elseif($next == "8") { $res = $db->Execute("SELECT * FROM ent_humor WHERE catagory='Quotes' ORDER BY title DESC LIMIT 80,10"); } elseif($next == "9") { $res = $db->Execute("SELECT * FROM ent_humor WHERE catagory='Quotes' ORDER BY title DESC LIMIT 90,10"); } elseif($next == "10") { $res = $db->Execute("SELECT * FROM ent_humor WHERE catagory='Quotes' ORDER BY title DESC LIMIT 100,10"); } elseif($next == "11") { $res = $db->Execute("SELECT * FROM ent_humor WHERE catagory='Quotes' ORDER BY title DESC LIMIT 110,10"); } elseif($next == "12") { $res = $db->Execute("SELECT * FROM ent_humor WHERE catagory='Quotes' ORDER BY title DESC LIMIT 120,10"); } elseif($next == "13") { $res = $db->Execute("SELECT * FROM ent_humor WHERE catagory='Quotes' ORDER BY title DESC LIMIT 130,10"); } elseif($next == "14") { $res = $db->Execute("SELECT * FROM ent_humor WHERE catagory='Quotes' ORDER BY title DESC LIMIT 140,10"); } elseif($next == "15") { $res = $db->Execute("SELECT * FROM ent_humor WHERE catagory='Quotes' ORDER BY title DESC LIMIT 150,10"); } elseif($next == "16") { $res = $db->Execute("SELECT * FROM ent_humor WHERE catagory='Quotes' ORDER BY title DESC LIMIT 160,10"); } elseif($next == "17") { $res = $db->Execute("SELECT * FROM ent_humor WHERE catagory='Quotes' ORDER BY title DESC LIMIT 170,10"); } elseif($next == "18") { $res = $db->Execute("SELECT * FROM ent_humor WHERE catagory='Quotes' ORDER BY title DESC LIMIT 180,10"); } elseif($next == "19") { $res = $db->Execute("SELECT * FROM ent_humor WHERE catagory='Quotes' ORDER BY title DESC LIMIT 190,10"); } elseif($next == "20") { $res = $db->Execute("SELECT * FROM ent_humor WHERE catagory='Quotes' ORDER BY title DESC LIMIT 200,10"); } $prev = $next - 1; if($prev == "0") { $prev = ""; } $next = $next + 1; ?> if($prev > "0" || $prev == "") { echo "<< previous 10 items
"; } ?> if($next < "21") { echo "next 10 items >>
";
}
?>
while(!$res->EOF)
{
$row=$res->fields;
//echo "Title - $row[title]
$row[content]
";
echo "Title - " . $row['title'] . "
\n " . parseContent($row['content']) . "
\n\n";
$res->MoveNext();
}
?>
html_end();
?>