GoFuckYourself.com - Adult Webmaster Forum - View Single Post

e32o · 03-01-2007, 11:05 AM

Hey guys, anyone know how to make the template to have TGP Rotator only show a certain month of galleries for archive pages basically.

Here is what I have so far but doesnt work right.

Code:

<%GALLERIES
AMOUNT 500
STATUS Used
CATEGORY Main
HTML Text
%>

Also it has something about adding in a WHERE part to this, something like this would display everything thats 5 days old.

Code:

WHERE Display_Date <= ADDDATE('$MYSQL_DATE', INTERVAL 5 DAY)

I basically want to display like all galleries from February 2007, then on another page display all of Janurary 2007 and so on.
Anyone know of a way to get this done?

Thanks for any help.

03-01-2007, 11:05 AM
e32o Registered User Join Date: Feb 2003 Posts: 39	TGP Rotator Template Help Needed Hey guys, anyone know how to make the template to have TGP Rotator only show a certain month of galleries for archive pages basically. Here is what I have so far but doesnt work right. Code: <%GALLERIES AMOUNT 500 STATUS Used CATEGORY Main HTML Text %> Also it has something about adding in a WHERE part to this, something like this would display everything thats 5 days old. Code: WHERE Display_Date <= ADDDATE('$MYSQL_DATE', INTERVAL 5 DAY) I basically want to display like all galleries from February 2007, then on another page display all of Janurary 2007 and so on. Anyone know of a way to get this done? Thanks for any help.