can i exec update via time

[redarrow]

is it possable to get the script to update a database afther 5 mins cheers


example needs help theo cheers.

[code]

<?php

database connection

while loop assoc


$current_time = $row['curent_time'];

$time_change= $row['time_chage'];

$time_change = $current_time;

$time = $current_time - $time_change;

if($time ) {


header(" location: http://delete.php");
}

?>

[/code]

[joquius]

you'd need a page open which would refresh itself after 5 minutes

[redarrow]

[!--quoteo(post=383162:date=Jun 13 2006, 09:11 AM:name=joquius)--][div class=\'quotetop\']QUOTE(joquius @ Jun 13 2006, 09:11 AM) [snapback]383162[/snapback][/div][div class=\'quotemain\'][!--quotec--]
you'd need a page open which would refresh itself after 5 minutes
[/quote]

so to get a header to work a [page must be open to work or anythink else useing a time idear.

[joquius]

you'll need the page open to run the php script or have some other page open it. You could get a javascript page to load the page after 5 minutes and run the query on the load of the page.

[redarrow]

from your point of view and cheers how to get throw this task of mine.

A user reads there message and the database gets a saved copy in a field then 5 mins later the message the message read is deleted.


Does it sound possable cheers.

[joquius]

add a field to the db as "pending delete" with a time of deletion, then add a function on each page load of the messaging service with deletes messages where time() > pending_delete && message_read = 1 or something similar. In any case it will not matter when the message is deleted because it will happen before the next page view in any case.

[redarrow]

[!--quoteo(post=383174:date=Jun 13 2006, 09:43 AM:name=joquius)--][div class=\'quotetop\']QUOTE(joquius @ Jun 13 2006, 09:43 AM) [snapback]383174[/snapback][/div][div class=\'quotemain\'][!--quotec--]
add a field to the db as "pending delete" with a time of deletion, then add a function on each page load of the messaging service with deletes messages where time() > pending_delete && message_read = 1 or something similar. In any case it will not matter when the message is deleted because it will happen before the next page view in any case.
[/quote]

Thank you so much you understood me so well cheers.

ps.You havent got any made php tutoral by your self online have you cheers.

[joquius]

Well I'm actually at work :) ...though I spend 10% of my time here working :P
I don't know if I have time to write one right now.

[redarrow]

[!--quoteo(post=383180:date=Jun 13 2006, 10:06 AM:name=joquius)--][div class=\'quotetop\']QUOTE(joquius @ Jun 13 2006, 10:06 AM) [snapback]383180[/snapback][/div][div class=\'quotemain\'][!--quotec--]
Well I'm actually at work :) ...though I spend 10% of my time here working :P
I don't know if I have time to write one right now.
[/quote]

Got that mate will do so ok.


Thank you for your help cheers.