$ShowNumPosts = 15; if(isset($_POST['startingPostID'])) { $startingNum = $_POST['startingPostID']; if($startingNum < 0) $startingNum = 0; } else $startingNum = 0; //echo $startingNum; ?>
Your Source for Reggae/Rock/Acoustic News...and more.
|
Sublime News Blog
0)
{
$newNum = ($startingNum - $ShowNumPosts);
?>
}
$host="localhost"; // Host name
$username="thepier0_thepier"; // Mysql username
$password="nuttmeg2"; // Mysql password
$db_name="thepier0_blog"; // Database name
$tbl_name="wp_posts"; // Table name
// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$posts_sql_statement = "SELECT * FROM wp_posts as p INNER JOIN wp_term_relationships AS tr ON (p.ID = tr.object_ID AND tr.term_taxonomy_id = 6 ) INNER JOIN wp_term_taxonomy AS tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id AND taxonomy = 'category') WHERE p.post_status = 'publish' ORDER BY p.post_date DESC LIMIT " . $startingNum . ", " . $ShowNumPosts;
//echo $posts_sql_statement;
$post_count_sqlstatement = "SELECT COUNT(*) FROM wp_posts as p INNER JOIN wp_term_relationships AS tr ON (p.ID = tr.object_ID AND tr.term_taxonomy_id = 6 ) INNER JOIN wp_term_taxonomy AS tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id AND taxonomy = 'category') WHERE p.post_status = 'publish' ORDER BY p.post_date DESC";
$posts_sql_result = mysql_query($post_count_sqlstatement)
or die(mysql_error());
$posts_row = mysql_fetch_array($posts_sql_result, MYSQL_NUM);
$numOfPosts = $posts_row[0];
//echo "
". $numOfPosts; $posts_sql_result = mysql_query($posts_sql_statement) or die(mysql_error()); while($posts_row = mysql_fetch_array( $posts_sql_result )) { ?> if($numOfPosts > ($startingNum + $ShowNumPosts)) { $newNum = $startingNum + $ShowNumPosts; ?> } ?> |
Recent Additions
Exclusive MP3 Leak
Upcoming Album Releases
|