Thread

{exp:query sql="
     SELECT 
     SUM(total_forum_topics+total_forum_posts) 
     AS total_forum_posts_for_rank 
     FROM exp_members 
     WHERE member_id = '<?php global $SESS; echo $SESS->userdata['member_id'];?>' "}
          {exp:query sql="SELECT rank_title FROM exp_forum_ranks WHERE rank_min_posts <= '{total_forum_posts_for_rank}'"}
               {if count == {total_results}}{rank_title}{/if}
          {/exp:query}
{/exp:query}

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''

Filename: modules/query/mod.query.php

Line Number: 181

<?php global $SESS; echo $SESS->userdata['member_id'];?>

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: libraries/Functions.php(680) : eval()'d code

Line Number: 50

{exp:query sql="
     SELECT 
     SUM(total_forum_topics+total_forum_posts) 
     AS total_forum_posts_for_rank 
     FROM exp_members 
     WHERE member_id = '{logged_in_member_id}' "}
          {exp:query sql="SELECT rank_title FROM exp_forum_ranks WHERE rank_min_posts <= '{total_forum_posts_for_rank}'"}
               {if count == {total_results}}{rank_title}{/if}
          {/exp:query}
{/exp:query}

{exp:query sql="
     SELECT 
     SUM(total_forum_topics+total_forum_posts) 
     AS total_forum_posts_for_rank 
     FROM exp_members 
     WHERE member_id = '{logged_in_member_id}' " parse="inward"}
          {exp:query sql="SELECT rank_title FROM exp_forum_ranks WHERE rank_min_posts <= '{total_forum_posts_for_rank}'"}
               {if count == {total_results}}{rank_title}{/if}
          {/exp:query}
{/exp:query}

$this->EE =& get_instance();
$member_id = $this->EE->session->userdata['member_id'];

{exp:query sql="
     SELECT 
     SUM(total_forum_topics+total_forum_posts) 
     AS total_forum_posts_for_rank 
     FROM exp_members 
     WHERE member_id = '<?php echo $member_id; ?>' "}
          {exp:query sql="SELECT rank_title FROM exp_forum_ranks WHERE rank_min_posts <= '{total_forum_posts_for_rank}'"}
               {if count == {total_results}}{rank_title}{/if}
          {/exp:query}
{/exp:query}