I felt dumb when I realized, but make sure $db_name is set to the right database. I got the same error as you guys before:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xxx/public_html/lastposts3.php on line 48

I'd like to have this but in a all the vb pages.
I know there are many hacks for that but not for all pages, and if there are they display many details and requiere mayor edits.
Is there any way to include a php file from a template like footer or header?

i have solved this creating a new variable containing the file in the phpinclude_start template. Then in just insert that variable where i want this displayed.
This is working in all pages except in showthread.php and forumdisplay.php where i get this error
This is line 47 in /includes/lastpost.php
how can i solve it?

My line 47 is actually line 48 of the original file

Just saw the fixed file by therczone. I'll try it now.
What's suppoused to be my thread prefix?
db table prefix?

I really don't know what's wrong with this i did all the suggested in this thread, but the error is still there.
Can someone help me?

This is a great hack.
I use it a lot into my website.
I would like to show also 400 first characters of a post below the link. I tried to select the text through the mysql sentence, but it appears unformatted (no spidering tags).
Anyone knows how to do this?

Thanks in advance

if u dont use a prefix u delete this line YOURPREFIXHERE_ in both instances for people who are having trouble...

Also the error message :
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/traffic/public_html/marketingpatch/lastposts.php on line 48

How do I get this to exclude forums as well? Also, does it respect viewable permissions so it won't show mod forum posts to people that aren't allowed?

Thanks.