![]() |
![]() |
![]() |
||||
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
|
New Webmasters ask "How-To" questions here. This is where other fucking Webmasters help. |
|
Thread Tools |
![]() |
#1 |
Confirmed User
Join Date: Dec 2005
Posts: 127
|
Autogallery SQL order by date and weight?
Im trying to gte a handle on my template scripts.
I want to display sections with today, yesterday and 2 days ago. This is my current template <%GALLERIES HASTHUMB 1 TYPE Submitted CATEGORY pictures AMOUNT 30 PAGEDUPES False GETNEW True ORDER Weight DESC REORDER Weight DESC HTML Thumb INSERT { LOCATION +1 HTML </tr><tr> } %> Is the following correct for today and yesterdays section, for galleries sorted by date and weight?? <%GALLERIES HASTHUMB 1 TYPE Submitted CATEGORY pictures AMOUNT 30 PAGEDUPES False GETNEW False ORDER Display_Date 2006-09-17, Weight DESC REORDER Display_Date 2006-09-17, Weight DESC HTML Thumb INSERT { LOCATION +1 HTML </tr><tr> } %> <%GALLERIES HASTHUMB 1 TYPE Submitted CATEGORY pictures AMOUNT 30 PAGEDUPES False GETNEW False ORDER Display_Date 2006-09-16, Weight DESC REORDER Display_Date 2006-09-16, Weight DESC HTML Thumb INSERT { LOCATION +1 HTML </tr><tr> } %> Sorry, im just unsure about how to get the ORDER to work with two functions. Thanks for your help! |
![]() |
![]() ![]() ![]() ![]() |
![]() |
#2 |
Confirmed User
Join Date: Dec 2005
Posts: 127
|
fiddled around and the wonders of trial and error...
This probably not the most elegant solution but it works... here it is for anyone searching gfy for a solution in the future. <%GALLERIES AMOUNT 25 WHERE Category='pictures' AND Approve_Date = '2006-09-16' REWHERE Category='pictures' AND Approve_Date = '2006-09-16' ORDER Weight DESC REORDER Weight DESC HTML Thumb INSERT { LOCATION +1 HTML </tr><tr> } %> |
![]() |
![]() ![]() ![]() ![]() |
![]() |
#3 |
Confirmed User
Industry Role:
Join Date: Nov 2003
Location: Olongapo City, Philippines
Posts: 4,618
|
Look at the AGE, MAXAGE and MINAGE directives
|
![]() |
![]() ![]() ![]() ![]() |