Adult Script Pro Community Forums

The forum is here for legacy reasons. No new posts will be created. User registration is disabled! If you have any questions, please email us or check https://www.adultscriptpro.com for more details!

You are not logged in.

#1 2011-11-12 09:38:45

Eri
Member
Registered: 2011-03-18
Posts: 977

show latest video thumb from each category

At http://mysite.com/categories/ is there a way to show latest video thumb from each category.


Best Adult Affilitate Network:
ExoClick
Best Deals on Dedicated Servers - CDN
INXY

Offline

#2 2011-11-14 05:30:08

jimmyblaze
Member
From: NY
Registered: 2011-07-13
Posts: 57
Website

Re: show latest video thumb from each category

That would be great.

Offline

#3 2011-11-14 09:38:58

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: show latest video thumb from each category

To get the info fromt he database you can use the following query:

SELECT COUNT(c.cat_id) AS total, c.cat_id, v.video_id, v.slug, v.thumb FROM video_category AS c INNER JOIN video AS v ON (v.video_id = c.video_id) GROUP BY c.cat_id HAVING total = 1;

Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

Board footer

Powered by FluxBB