[drupal-support] sql guru pager question
Bèr Kessels
berdrupal at tiscali.be
Thu Mar 17 23:15:02 UTC 2005
Hi there
$result = pager_query(db_rewrite_sql("SELECT DISTINCT u.uid, u.name FROM
{users} u LEFT JOIN {node} n ON n.uid = u.uid WHERE n.type = 'blog' AND
n.status = 1 ORDER BY n.created DESC"), variable_get('default_nodes_main',
10));
seems to break on the pager. Look here http://staging.webschuur.com/blog/list
for what I mean. DISTINCT correctly removes all users that have no blog
entries. But either the pager, or the JOIN breaks the amount in the pager.
Anyone there who hasa n idea whats going on here?
Bèr
--
| Bèr Kessels | webschuur.com | website development |
| Turnhoutsebaan 34/3 | 2140 Antwerpen | België |
| IM: ber at jabber.org.uk | MSN: berkessels at gmx.net |
| pers: bler.webschuur.com | prof: www.webschuur.com |
Regards,
Bèr
--
[ Bèr Kessels | Drupal services www.webschuur.com ]
More information about the drupal-support
mailing list