View Single Post
Old 09-17-2006, 02:23 AM  
MonkeyG
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!
__________________


Got Hardcore Traffic / Galleries?? Trade / Submit
MonkeyG is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook