On Thu, Oct 20, 2005 at 05:31:07AM +0200, Jad Madi wrote: use user_load() or node_load() they return it all. the first returns only the user, the second one the node and the user. drupaldocs.org will tell you more.

Ber

$result = db_query("SELECT n.uid, n.created, n.title, n.nid, n.changed FROM site_node n WHERE n.type = 'blog' ORDER BY n.changed DESC LIMIT 50");

any idea how to add one more query to get username/picture behind the post?

[ Drupal support list | http://lists.drupal.org/ ]