difficulties with inc_features - please help

[observer]

To my best knowledge, everything in inc_features at my site should be ok. Photopost itself is running perfectly, but I cant't get inc_features to display pictures on a custom page.

If I run inc_features.phpo, these are the errors I get:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/virtual/site4/fst/var/www/html/gallery/inc_features.php on line 49

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/virtual/site4/fst/var/www/html/gallery/inc_features.php on line 63

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/virtual/site4/fst/var/www/html/gallery/inc_features.php on line 115


If I call inc_features from another .php page like this:

<?
include "/home/virtual/site4/fst/var/www/html/gallery/inc_features.php";

echo "$photopostfeature" ;
?>

I get a display that says "Featured Photos", but doesn't show pictures at all.
So what am I doing wrong here?

[Chuck S]

If you have the forum and photopost in separate databases you need to uncomment the mysql_select_db lines as the instructions state and point to the proper database etc so everything can be found

[observer]

I don't. They are in the same database.

[Chuck S]

Okay so you say they are in the same database forum and photopost

Okay in your integration settings make sure you have the proper table prefix entered for photopost

[observer]

That shouldn't be the problem either.

Forum integration works flawless. It's skinned like vb3, cookies work, everything ok. I just can't get inc_features working.

Addendum:

When I include $pohotopostfeature in the template for forumhome, it displays links with the relative path to picture and the name of the one who posted it, but no picture (no thumbnail).

[Chuck S]

Well obviously you have changed something if your not getting mysql errors now. I need you to post a url so I can see what your doing more than likely in your config-int.php INTEGRATION OPTIONS you have the data url set incorrectly if it is not displaying pictures

[observer]

Mailed you my config-int.php and the url. Thanks in advance.

Bernhard

[climber]

OK, so the inc_features.php file is what folks are using to display a picture(s) on their home page, or any other page in their site - correct? looking at the code it appears that you have a choice between random, most_view, latest for what you want to show. is there a way to display the latest picture in a particular category? I have a category on my site/gallery called Cover Shot. I want to always display the latest shot from that category on my home page plus it's title and description. I'm sure I can write something to do this, it's hardly rocket science, but it would be nice if this were already done & I'm lazy.

thanks...

[Chuck S]

change this say

AND p.cat !=500

to say

AND p.cat=521

where 521 is the cat you want to pull from