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!

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>
}
%>

Look at the AGE, MAXAGE and MINAGE directives