AutoGallery SQL problem

flashingfrank · 2005-04-20, 01:45 PM

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

2005-04-20, 01:45 PM	#1
flashingfrank Internet! Is that thing still around? Join Date: Apr 2005 Posts: 3	AutoGallery SQL problem 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