[Zizou_SCD]

I am not linking to any vBulletin files. It's an unfeasible solution to the problem.

I have a piece of PHP code which is printing the 5 latest topic titles with the last post and poster name.

I want to get the last posters avatar in on the act here as well.

The query I have at the moment is:

select a.*, b.pagetext, b.postid from vb_thread a inner join vb_post b on a.lastpostid = b.postid  order by a.lastpost desc limit 0,5;

Is there a simple way to adapt with query to bring back an avatar path as well?