showing a list of new products

[davie_ne1]

Is it possible to create a search query that would show all products added in the last 30 days for example.

I know that actinic records the date that the product was last amended. When you view the actinic database using access, you can see the date last ammended info associated with each product.

I run a sweet shop and am constantly adding new lines (around 50 a week at the moment). I know that I could do this by creating a customvar stating something like "new" and then doing a search for all "new" products using that customvar. This would be time consuming method and I would prefer a automatic method if possible

[jont]

Actinic uses static HTML to generate the pages and not a dynamic database to query on the fly.

Searchable CUSTOMVARS are the obvious solution in Actinic (you may be able to automate this with a database query) and/or creating duplicates in a "new arrivals" section.

You may be able to link through to a MYSQL database on the server to run a query from outside of Actinic proper but will leave that for someone else who knows about such things ... Bill (amongst others) is a bit of a whizz at such things

[davie_ne1]

thats what I thought but you have to ask

The non-database driven side to actinic does cause alot of restrictions .....

never mind, I still think that actinic is one good piece of kit

Davie

[party_pete]

David - after having a nose around your site(very nice) I notice you use phpwebscripts.com/linkupgold/

How did you find the set-up, functionality, etc?

[davie_ne1]

I bought all their scripts last year for a affiliate site that I was setting up

http://www.affiliatessearch.co.uk/

I needed a bit of tweaking for importing hugh lists of affiliate programs and the use of i-frames.

But their tech support was great and very easy to set the scripts up. All you need is a mysql database on the server.

I would highly recommed them.

[jont]

The non-database driven side to actinic does cause alot of restrictions .....

The strength of static pages (fantastic SEO) is also its main limitation (non dynamic queries) .... but as you say a fantastic ... better to get people to the site in the first place andby the owner spending back-office time sorting the navigation etc IMHO