Hi everyone, I need some advice please.
I have an array of "thread ids". I check the status of the thread and if the field "hold_for_ten" = 1 and the thread is older than 10 minutes, then the thread has expired and i reset some values.
The following code does that and it updates OK...
$datecut=time()-600;
while ($thread=$DB_site->fetch_array($threads)) {
if ($thread[hold_for_ten] == '1' AND $thread[holder_timestamp] < $datecut){
$DB_site->query("UPDATE thread SET hold_for_ten = '0',holder_name = '',holder_timestamp = '0' WHERE threadid ='".$thread[threadid]."'");
}
The thing is... if reset some values that means I have to requery the array to get the latest values to output...how do I do that?
Thanks for any help