[drupal-support] latest posts with username/pic

[=?unknown-8bit?B?Quhy?= Kessels]

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/ ]