title: How to make two $db->query from the same table with two different ORDER by column that each other stand independenty in one php page?
body: <p>I want to make two blocktables in one page from the same DB table. The first blocktable I want to ORDER it by "posted_date" column, and the second I want to ORDER it by "numviews" column. I want the both blocktables not influence each other, altough they're on the same page. Is it possible?</p>
  
  <p>I have made like this, </p>
  
  <p>first block</p>
  
  <pre><code>$popresult = $db-&gt;query('
      SELECT 
          t.id, 
          t.poster, f.id AS forum_id, 
          f.forum_name, 
          t.subject, 
          t.mainimg, 
          posted_date, 
          t.num_views 
      FROM '.$db-&gt;prefix.'forums 
      ORDER BY 'posted_date' DESC 
      LIMIT '.$numtopik.'', true) 
  or error('Tidak dapat mengambil topik populer', __FILE__, __LINE__, $db-&gt;error()); 
  </code></pre>
  
  <p>second block</p>
  
  <pre><code>$popresult = $db-&gt;query('
      SELECT 
          t.id, 
          t.poster, 
          f.id AS forum_id, 
          f.forum_name, 
          t.subject, 
          t.mainimg, 
          posted_date, 
          t.num_views 
      FROM '.$db-&gt;prefix.'forums 
      ORDER BY t.num_views DESC 
      LIMIT '.$numtopik.'', true) 
  or error('Tidak dapat mengambil topik populer', __FILE__, __LINE__, $db-&gt;error());
  </code></pre>
  
  <p>but it still got error to fetch.</p>
  
  <p>Can anybody help me please?</p>