irkevin

Hi, i tried the solution mentioned, i was testing this locally.. But the problem still persist in the header and footer part of the website..

Hi, thanks for replying.. link below

Link

Ok i got it to work.

I’ll explain what I need in case someone else needs it

Things I’ve noticed is:

When using query_post, it overrides the default behaviour..

So what i did is add a condition to check if it’s a tag. like below

<?php
     if(is_tag()){
         $tag = get_query_var('tag');
         query_posts('tag='.$tag);

        while (have_posts()) : the_post();
?>
Output the html along with the title here

<?php
    endwhile;
}else{
    // query_posts for your categories here
?>

If I missed something, let me know

I also tried passing

tag__in

But with no luck!! Hope someone can help :S

Ok, finally, I succeeded in my quest ??

Below is the actual code to get the pagination working.. If permalink is ON, it will use a nice link else it will use the default one.

Here is a link to the code

The code:
https://www.mu-anime.com/code/code.txt

The pagination class
https://www.mu-anime.com/code/pagination.txt

Hope it works if you need it!

An example can be found there:

https://www.mu-anime.com/new/category/animes

The subcategories are being displayed and I’m able to paginate them ?? I limited the result to two now since I’m still customizing the site. Couldn’t do it with the PageNavi Plugin since it was paginating only post. I don’t know how to create a plugin, else I would have convert this to a plugin.

Ok almost everything is done now, expect on little problem which I cant seem to fix.

When using permalink, when I click next, the link goes like this

category/animes/page/2

But when I want to go back, the link is messed up like this

animes/page/animes/page/1

Why is it listing it twice?

Ok, nevermind I made it.

I made it so that when permalink is ON, use a nice url, and when it’s OFF, use the query string instead.

I will explain how I made it.

I used a pagination class I wrote a while back.

It can be found here

https://www.mu-anime.com/code/pagination.txt

In the page where you want the subcategories to show, use the code below

<?php
	//include the paginate class. I put it in the theme folder
	include("paginate.php");

	// This is the SQL Query to get the number of rows I have
	$count = "SELECT COUNT(*) FROM $wpdb->terms AS t
		     INNER JOIN $wpdb->term_taxonomy AS tt
		ON t.term_id = tt.term_id WHERE tt.taxonomy
               IN('category') AND tt.parent = '9'";	

	$number =  mysql_query($count);
	$row = mysql_fetch_array($number);
	$num_rows = array_shift($row);

	// Define some variable to hold our pagination settings
	$page = !empty($_GET['current_page']) ? (int)$_GET['current_page'] : 1;

	$perPage = 2;

	$paginate  =  new sitePagination($page,$perPage,$num_rows);

	//the variables would be something like:
	$parent = 9;// your category parent ID
	$where = " tt.parent = '$parent'";
	$in_taxonomies = 'taxonomy';
	$orderby = 't.term_id';
	$order = 'ASC';

        //This is the actual SQL Query to fetch the Data from Database
        $query = "SELECT * FROM $wpdb->terms AS t
		INNER JOIN $wpdb->term_taxonomy AS tt
		ON t.term_id = tt.term_id WHERE tt.taxonomy
                IN('category')
	       AND tt.parent = '$parent' LIMIT {$perPage} OFFSET {$paginate->offset()}";

	$terms = $wpdb->get_results($query);

        // A foreach loop to output the data nice and clean
	foreach($terms as $term){
	     $cat_parent = get_category($term->parent);

             //Had to use the $cat_parent to build the link
             //if some has a better idea, would be nice
	 echo "<li>
                 <a href='".$cat_parent->slug.'/'.$term->slug."'>". $term->name ."</a>
              </li>";
	}

	// The Fun starts here, all the code below will generate our dynamic page number
       // The container class is the same as WP PAGENAVI
       // I'm using a custom pagination class I created
	echo "<div class='wp-pagenavi'>";

	echo "<span class='pages'>Page {$page} of {$paginate->totalPages()}</span>";
	if($paginate->totalPages() > 1){
		if($paginate->previousPageExists()){
                   if ( get_option('permalink_structure') ){
			echo '<a href="'.$cat_parent->slug.'/page/'.$paginate->previousPage().'">&raquo; Previous</a>';
		}else{
	          echo '<a href="?cat='.$cat_parent->term_id.'&current_page='.$paginate->previousPage().'">&laquo; Previous</a>';
	       }
	   }
       }

	for($i=1;$i < ceil($paginate->totalPages()) + 1;$i++){
		if($page == $i)
			echo '<span class="current">'.$i.'</span>';
		else
                       echo '<a href="'.$cat_parent->slug.'/?current_page='.$i.'">'.$i.'</a>';

	}

	if($paginate->totalPages() > 1){
		if($paginate->nextPageExists()){
                  if ( get_option('permalink_structure') ){
			echo '<a href="'.$cat_parent->slug.'/page/'.$paginate->nextPage().'">Next &raquo;</a>';
		}else{
			echo '<a href="?cat='.$cat_parent->term_id.'&current_page='.$paginate->nextPage().'">Next &raquo;</a>';
		}
	}
}

	echo "</div>";
?>

In the queries, be sure that tt.parent points to your category ID.

Use this in the htaccess, above the #BEGIN wordpress

<ifmodule mod_rewrite.c>
RewriteEngine On
RewriteRule category/animes/page/(.*)$ category/animes/\?current_page=$1[L]
</ifmodule>

Huh nobody can help on this?

Well, i dont have any clue how to fix the link :S

Well my point was .. more explanation below

I have a category called anime, in anime there will be more subcategories..

Imagine i have 500 subcategories in the Categories Anime, it’s much better to paginate those 500 Subcats.

Right now i have 3, but I’m going to add more.. The website is not finished XD

Now my only problem is about the link

Ohhh it’s working. But now there’s something i would like to modify.

Here is the link to check the Subcategories Pagination in action

https://www.mu-anime.com/new/category/animes

When I click on next, the URL goes like this

https://www.mu-anime.com/new/category/animes?current_page=2

Is there a way to make the url look nice and clean?

The query is working just fine!

Let me fetch some beers and attack the pagination part. Lol

It’s not showing anything.

I’m using this

<?php
//the variables would be something like:
$parent = 9;// your category parent ID
$where = " tt.parent = '$parent'";
$in_taxonomies = 'category';
$orderby = 't.term_id';
$order = 'ASC';
$limit = '0,100';

$query = "SELECT name FROM $wpdb->terms AS t INNER JOIN $wpdb->term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ($in_taxonomies) $where ORDER BY $orderby $order $limit";

$terms = $wpdb->get_results($query);

echo "<pre>";
print_r($terms);
echo "</pre>";
?>

What I want, is create a query to select all Subcategories in the Category 9.

Thnx a lot MichaelH,

I will try those and come back to you

wow it’s amazing.. no one knows how to achieve this? :s :s