PHP/MySQL Help

[freeflow]

Hi everyone

I need some help with a PHP/MySQL script.

What I’d like to do:

-Change the status of all MySQL entries that exceed a different number of days and fulfill certain conditions.
-Timestamp (MySQL) plus number of days (PHP variable read from each MySQL entry) >= than todays date.
-Change only entries that have the status = “0”
-Change their status to “3”

I hope this makes some kind of sense and you can use this description to help me?


Examples:

Timestamp 2010-07-23 20:18:18 + Number of days in MySQL = 30 to be used in PHP script & change status if <= Today
Timestamp 2010-06-23 17:15:01 + Number of days in MySQL = 90 to be used in PHP script & change status if <= Today
etc.

 

[smghost001]

$temp = strtotime($timestamp)/86400;
$numMYSQL = Number of Days in MySQL;

if ($temp - $numMYSQL < 1) {
//today
}
else {
// not today
}

something along those lines anyway coz i didnt rly understand what you need

 

[Kate]

Something like this:

UPDATE [[I]table[/I]]
SET status=3
WHERE DATE_ADD([[I]Timestamp column[/I]],INTERVAL [[I]number of days[/I]] DAY) >= CURDATE()
AND status=0

 

[freeflow]

Thanks for your replies. They helped me find the right code.

$temp = strtotime($timestamp. "+$days days")/86400;

$temp2 = time();

$temp2 = ($temp2)/86400;


if ($temp - $temp2 < 1) {

mysql_query("UPDATE Ads1 SET Status ='3'  WHERE ID = '$id' AND Status = '0'"); 

}

 

[smghost001]

no probs knew it was something along those lines you needed :P cheers