Hall of Fame

[khanowner]

Hi Alex,

I need few help to show video category on a video thumbnail.
http://izlenio.com/ this is my site and I have added view count, publish date etc. to above homepage videos.
And I want to add video's category to thumbnail. I cant call back video's category from video-loop.php.
I think I must add some php codes to video-loop.php to solve this.

Thanks for your help.

[PHPVibe A.]

Hi, first you need to join the categories table in the sql query (see com/com_video.php for a query sample), since in the video table you only have the category id.

[khanowner]

Alex,
Thanks for your reply. But I cant get category id with $video->category.
Or what must I do to get category id ?

Thanks.

[PHPVibe A.]

The query comes from the component which calls video-loop.php, there should be several query edits.
You should add category to the options queried from the database, also join the categories table and query the category name.

We didn't do this because it makes the queries heavier with an extra join.