Easy Time Stamp and Update Issue

[system]

Hey everyone,

I have been struggling for quite some time on this. So I need to ask for help.

Heres the scope of what needs to happen :

A value of an item (item) updates every 15 mins (update_time) by X (item_addtion) based on server time to SQL.

My Issues I run into :

1. However, “update_time” can be modified as well as “item_addtion”
2. No time counter needs to display
3. Need to apply this same code to more than one item.

So I connect to the Database, and it returns the “Item” value lets say 1. Then it checks a PhP file that determines the “update_time” ( which if i can return that as a value from the SQL that would great)

It then returns the “item_addtion” from the Database (SQL), and then should do it wheather im online on the page or not.

Then lets say every 15 mins “update_time” it adds +1 to the “Item” value in the SQL.

I hope this makes sense… New to this forum, so not sure if this should be cato as a SQL issue, or not.

Thanks Ahead for any help, ideas or solutions!

[mahbub.kuet]

Do you have AJAX knowledge ?
It can be done easily with AJAX.
You need a Javascript Code for measuring 15 mins.
Then write php code that response the XMLHttpRequest.
The PHP code will handle database for insert or update.