List of Articles for each author in ExpressionEngine

Below blog will describe the process to make a new page for article-list of each author. In the article list page OR article details page make a link from "Author Name" of that article with this new template/page. It will show you the list of articles published by that author. It will very useful for such blogging or news site, those have multiple authors and want to create such type of page.

There will be 2 templates for such, one will search the Article titles as per Author name and other will just embed that template and show in a decent manner.

Author Page:-
This template will show the list of articles of each author. Prepare the page-design as per your need and place the following type of of code in the body area OR where you want to show the list:-

{exp:weblog:entries weblog="weblog1|weblog2|weblog3" rdf="off" status="not closed|editing" limit="1" disable="categories|member_data|trackbacks" paginate="bottom" dynamic="on"<h1>{author_name}</h1><? $author = str_replace("'", "\'", "{author_name}"); ?>{embed=templategroup/author_query author="<? echo $author; ?>"}{/exp:weblog:entries}

Query Page:-
Following template is mainly responsible for searching the articles as per the author name from the database and prepare the list:-
{exp:query limit="12" paginate="bottom" sql="SELECT w.blog_name, t.title, t.url_title, t.entry_date, t.entry_id, d.field_id_12, d.entry_id, d.field_id_85 FROM exp_weblogs AS w, exp_weblog_titles AS t, exp_weblog_data AS d WHERE w.weblog_id = t.weblog_id AND t.entry_id = d.entry_id AND t.entry_date < field_id_12 =" '{embed:author}'" weblog_id ="4" weblog_id ="5" weblog_id ="7"><ul><hr/><a href="{path={blog_name}/view/{url_title}}" class="features1"><h3>{title}</h3></a><h5>{if field_id_12}{field_id_12} | {/if}{entry_date format="%j %M %Y"}</h5><h5>{field_id_85}</h5></ul>{paginate}Page {current_page} of {total_pages} : {pagination_links}{/paginate}{/exp:query}

Article List or View page Update :-
Just put the below type link from the Article author name with the Author page template as follows:-

{exp:weblog:entries weblog="weblog1|weblog2" status="open|not closed" limit="10" rdf="off" disable="categories|member_data|pagination|trackbacks"}<input type="hidden" name="au" value="{author_name}">{if thumbnail}<img src="{thumbnail}" alt="thumbnail" />{/if}<a href="{title_permalink=weblog1/view}"><h1>{title}</h1></a><p class="links"><a class="navLink" href="{title_permalink=sections/author_page}">{author_name}</a> | {entry_date format="%j %M %Y"}{if comment_total} | <img src="{imageurl}comments.gif" alt="comment" border="0" /> {comment_total}{/if}</p>{body}<hr/>{/exp:weblog:entries}


If you face any difficulty to integrate these code, feel free to put comments here. We will try to fix the problem.