pager_query

Fix for Fix for Example of pager_query

  1. $result = pager_query(
  2.       db_rewrite_sql(
  3.         "SELECT n.nid, n.title, n.changed, n.status
  4.         FROM {node} n
  5.           WHERE n.uid = %d
  6.         AND n.type = '%s'
  7.         ORDER BY n

Fix for Example of pager_query

  1. $result = pager_query(
  2.       db_rewrite_sql(
  3.         "SELECT n.nid, n.title, n.changed, n.status
  4.         FROM {node} n
  5.           WHERE n.uid = %d
  6.         AND n.type = '%s'
  7.         ORDER BY n

Fix for Example of pager_query

  1. $result = pager_query(
  2.       db_rewrite_sql(
  3.         "SELECT n.nid, n.title, n.changed, n.status
  4.         FROM {node} n
  5.           WHERE n.uid = %d
  6.         AND n.type = '%s'
  7.         ORDER BY n

Fix for Fix for Example of pager_query

  1. $result = pager_query(
  2.       db_rewrite_sql(
  3.         "SELECT n.nid, n.title, n.changed, n.status
  4.         FROM {node} n
  5.           WHERE n.uid = %d
  6.         AND n.type = '%s'
  7.         ORDER BY n

Fix for Example of pager_query

  1. $result = pager_query(
  2.       db_rewrite_sql(
  3.         "SELECT n.nid, n.title, n.changed, n.status
  4.         FROM {node} n
  5.           WHERE n.uid = %d
  6.         AND n.type = '%s'
  7.         ORDER BY n

Fix for Fix for Fix for Fix for Example of pager_query

  1. $result = pager_query(
  2.       db_rewrite_sql(
  3.         "SELECT n.nid, n.title, n.changed, n.status
  4.         FROM {node} n
  5.           WHERE n.uid = %d
  6.         AND n.type = '%s'
  7.         ORDER BY n

Fix for Fix for Fix for Example of pager_query

  1. $result = pager_query(
  2.       db_rewrite_sql(
  3.         "SELECT n.nid, n.title, n.changed, n.status
  4.         FROM {node} n
  5.           WHERE n.uid = %d
  6.         AND n.type = '%s'
  7.         ORDER BY n

Fix for Fix for Example of pager_query

  1. $result = pager_query(
  2.       db_rewrite_sql(
  3.         "SELECT n.nid, n.title, n.changed, n.status
  4.         FROM {node} n
  5.           WHERE n.uid = %d
  6.         AND n.type = '%s'
  7.         ORDER BY n

Fix for Example of pager_query

  1. $result = pager_query(
  2.       db_rewrite_sql(
  3.         "SELECT n.nid, n.title, n.changed, n.status
  4.         FROM {node} n
  5.           WHERE n.uid = %d
  6.         AND n.type = '%s'
  7.         ORDER BY n

Pager_query questions

  1. <?php
  2.  
  3. //If I want to rewrite this:
  4.  
  5. $sql = db_query("SELECT chorder, nid FROM {poll_votes} WHERE uid=%d", $user->uid);
  6.  
  7. //Using pager_query, that shows 2 nodes per page, is this right?
  8.  
  9. $sql
Syndicate content