[support] Using Drupal Pager in D5 Module

Fred Jones fredthejonester at gmail.com
Thu Aug 7 17:05:14 UTC 2008


> Ok; I would not have written you request the same, try:
>
> $sql = "SELECT nid, title, teaser FROM {node_revisions} WHERE body like '%%s%' GROUP BY nid ORDER BY nid";
> $sql_count = SELECT COUNT(DISTINCT(nid)) FROM node_revisions WHERE body like '%%s%'";

Ah, very good. I will use that. Thanks!


More information about the support mailing list