How can I set up recently viewed function on my site with Dynamic Suite?

I have dynamic suite: Data Assist,Security Assist, Universal Email,Ecart

I want to implement a recently viewed section into a div on site.

Can any one point me in the right direction as to how I can successfully implement this?

I have looked at some forums and get the impression sessions and cookies have a correlation to this. Can Data Assist or cookies Toolkit help me in this area?

i would create a new table for logs and register wich page is visited with date on timestamp to autoupdate depending on the user

Like Sades has mentioned I think it would be best to have this information in a table in your db. If you are not concerned about individual users then you could just have a table and have an update server behavior at the top of each page, you can then just insert a record into the db for each page in the site, then update that record when the page is loaded.

Thank you both to Sadie and Eric's for quick response

I have gone into phpAdmin to access database (using Mysql 5.1.44)

I have created a table called 'logs' with only following selections:
in Field:'logs' Type:'TIMESTAMP' Default: 'CURRENT_TIMESTAMP'

Do I need to auto increment or set any other options?

I tried to set options you mentioned Sadie by choosing TYPE:Date and Default: TIMESTAMP (on mine, option is CURRENT_TIMESTAMP) however an error appears that prints "#1067 - Invalid default value for 'logs' "

Did I set it right? Please forgive me if I got it wrong as I am new to this but not affraid to get stuck in.

Thanks

I would add an id column to this table to add as the primary key, it should be unique, not null and auto increment. As for setting the default value if you can't get it worked out in the db you can do this in the php code for the inserted value. If you would like a full date and time entry for the current time the value you would use in php would look like this:

<?php echo date("Y-m-d H:i:s", time()); ?>

Thanks for the code Eric, only thing is I don't know how to apply it yet.

In regards to MySql setup I would like to make sure it is set up in exactly the same way you know it to work (i.e. customers who may look at products on a site can view recently viewed products) so I have attached 2 images from phpadmin.

One displays error I received in attempt to set DATE and CURRENT_TIMESTAMP.

The other shows the setup now in relation to info I have received in this thread.

Could you please confirm settings are correct. I followed what you said in regards to id column. However because I cannot set that date option in the other field I feel it may not work.

Thanks.

ok for the field you selected date dont do that select timestamp and on attributes you can select update timestamp, you would also need a field where you store wich section is been view, i also add a ipaddress field to store the adress from the visitor

Thanks again Sades for you input.

I tried to set attribute to auto update as you said but that option is not available in phpadmin please see jpeg.

The only options available there are SIGNED, UNSIGNED and UNSIGNED ZEROFIELD. I am completely confused.

What do you use to set up your database?

Also I have included jpeg of current setup any tips are most welcome.

Do I need to have 2/ 3 fields i.e:

logID: INTEGER, PRIMARY, UNIQUE, AUTOINCREMENT,
logs: TIMESTAMP, CURRENT_TIMESTAMP
logIP:?

Thanks again for your help.

Still awaiting some insight from technical support on this issue.

Can someone please reply.

When you are updating the records you can set the time column to the following value:

<?php echo date("Y-m-d H:i:s", time()); ?>

This will set the column to the current date and time when updated. As for setting the default value of the db I'm not sure why you are not able to do this. Setting the value directly in the insert or update server behavior should have the same effect.