<ul><li>It must be locally downloadable<li>It needs to have premiered in the past<li>It needs to be the most recent, sorted by premier date, then by entry date<li>It can't be hidden (not sure what that flag means...)</ul>LightningCountX wrote:How do you get your video on New Vid On The Block?
select vid_id, title from videos where local = 'TRUE' and local_hidden = 'FALSE' and date_premiered < now() order by date_premiered desc, date_entered desc limit $limitReturn to Site Help & Feedback
Users browsing this forum: No registered users and 1 guest