17 Mar
2005
17 Mar
'05
11:15 p.m.
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@jabber.org.uk | MSN: berkessels@gmx.net |
| pers: bler.webschuur.com | prof: www.webschuur.com |
Regards,
Bèr
--
[ Bèr Kessels | Drupal services www.webschuur.com ]