example of using pager_query()

The code is so complicated. Can you give me a simple one ? It will be better if you can show me a simple module . Thanks for your supporting

friend

here i have some problem with pager_query

$sqlquery="SELECT profile.nid,profile.field_name_value,profile.field_age_value,profile.field_sex_value,profile.field_height_value,t1.name AS caste,t2.name AS religion,t3.name AS location,files.filepath AS imgloc FROM {content_type_profile} AS profile INNER JOIN term_data AS t1 ON profile.field_caste_tid=t1.tid INNER JOIN term_data AS t2 ON profile.field_religion_tid=t2.tid INNER JOIN term_data AS t3 ON profile.field_location_tid=t3.tid LEFT JOIN files ON (files.nid=profile.nid-1 AND files.filename='".$Imagetpe."') WHERE profile.field_sex_value='".$sex."'";

$Countqry="SELECT COUNT(*) FROM {content_type_profile} AS profile INNER JOIN term_data AS t1 ON profile.field_caste_tid=t1.tid INNER JOIN term_data AS t2 ON profile.field_religion_tid=t2.tid INNER JOIN term_data AS t3 ON profile.field_location_tid=t3.tid LEFT JOIN files ON (files.nid=profile.nid-1 AND files.filename='".$Imagetpe."') WHERE profile.field_sex_value='".$sex."'";

$sqlquery=$sqlquery." AND profile.field_age_value BETWEEN'".$age_lower_limit."' AND '".$age_upper_limit."' ORDER BY profile.nid DESC";

$GL_count_query=$Countqry." AND profile.field_age_value BETWEEN'".$age_lower_limit."' AND '".$age_upper_limit."'";

$result=pager_query($sqlquery,10,0,$GL_count_query);

while($data= db_fetch_object($result))
{
//,...............some code here
}

$search_result = theme('table',$header,$newdata);
$srch_rslt .=$search_result;
$srch_rslt .=theme('pager');

it is showing ten records but there is no links other result page

I've adapted examples from the Drupal site to come up with the below code. I get the pager display with the correct number of pages based on the number of records meeting the SELECT criteria, but instead of data returned from the database, I get:

"Resource id #74Resource id #74Resource id #74Resource id #74Resource id #74Resource id #74Resource id #74Resource id #74Resource id #74Resource id #74Resource id #74Resource id #74".

What do I need to do to get the actual data to display? Any help greatly appreciated.

function pager_test(){

drupal_set_title("Pager Test");

//This is numbers per page
$num_per_page = 12;

//actual query
$query = "SELECT STORE_ID AS ID, STORE_STATE AS STATE FROM {stores} WHERE STORE_STATE = 'SC'";

//the count query should be similar to the query above
$count_query = "SELECT COUNT(*) AS row_count FROM {stores} WHERE STORE_STATE = 'SC'";

//pager_query function
$rs = pager_query($query, $num_per_page, 0, $count_query);

while ($data = db_fetch_object($rs)){
$output .= $rs;
}

//dont forget
$output .= theme('pager');

return $output;
}

Because i'm so new to drupal, Can you show me how it works in a simple module ? I mean if you can show me a demo for that . Thanks you very much .

Drupal Pagination is for database queries, if you are constructing your array in a different way, you'll have to custom create the pagination as far as I know.

However, presumably at some stage you are collecting information from the database, although it could be well before that array is constructed.

How do you know how many rows there will be in your table anyway?

Dave

My site: http://www.unitorganizer.com/myblog

Have you tried using the LIMIT clause? SELECT * FROM ... ORDER BY ... LIMIT 50

Nancy Dru (formerly Nancy W. until I got married to Drupal)

I don't see how this could work, but I am far from a MySql expert.

I'd like to see your example meet Drupal coding standards. Also, with the simple query you are using, a count query is unnecessary.

First you would have to render your list as an OL (which can be done with theme('item_list',...))The page function places a "page" query string in the URL, so it would be available in $_GET. You could then multiply that by the number of results per page and use that in the "start" attribute.

NancyDru (formerly Nancy W. until I got married to Drupal)

Look at the comments for the pager.inc file (in /includes folder).

To have more than one pager query per page assign each an $element value.

Your coding syntax may vary, but the $element tells Drupal which pager_query is which.

You can use 0 as your first $element value for the first pager_query, 1 for the next, and so on.