ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Query Help

November 10, 2008 9:45am

Subscribe [1]
  • #1 / Nov 10, 2008 9:45am

    simplyee

    104 posts

    Hi all. I have this query to display entries from authors in the search results, and it works, but I would like to limit to a certain weblog id and just can’t seem to get it right.

    {exp:query sql="SELECT member_id, total_entries FROM exp_members WHERE group_id='1' ORDER BY total_entries DESC LIMIT 12"}
    <a href="http://www.mysite.com/?ACT=19&result_path=search/results&mbr={member_id}">_Find more posts by this author_</a>
    {/exp:query}

    How to limit it to just showing the entries from one weblog?

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases