AutoGallery SQL problem

[frankthetank]

Originally Posted by flashingfrank

hello everyone!

i am testing the free version of agsql.
before i buy a licence i wanted to know if the following is possible:

i want to have 4 tables with 5x5 thumbs.
every table represents one day. (galleries in the first table are 1 day old, in the second 2days...)

the first three rows should include submitted galleries and the last two permanent ones.

which code do i have to use to get the permanent galleries, that have been shown in the first table one day ago, to display in the second table.

i believe this is a pretty commen task, but i can´t figure out the code.


greetz
ff

There isn´t a free version of autogallery sql. The free version is autogallery and it doesn´t use a database, just a plain textfile.

You can group submitted galleries with the free version, but permanent galleries must be done with manual coding. That´s where the freeversion and the sql version differ. And the free version doesn´t support thumbs.

Here is an example of templates for two days. Just add more templates to get more different dates. You can add the date of posting as well.

<%TEMPLATE
NAME Today
HTML <a href="##Gallery_URL##" target="_blank">##Description##</a><br />
%>

<%TEMPLATE
NAME Yesterday
HTML <a href="##Gallery_URL##" target="_blank">##Description##</a><br />
%>

In the html code of your page you have to refer to the templates defined in the head of your page.

But you have to read the manual as well, it´s very instructive for this problem.