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!
__________________
Got Hardcore Traffic / Galleries?? Trade / Submit
|