PHP/MySQL Help

freeflow · 07-23-2010, 06:34 PM

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”
????: NamePros.com http://www.namepros.com/programming/668411-php-mysql-help.html
-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 · 07-24-2010, 08:10 AM

$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

sdsinc · 07-24-2010, 10:16 AM

Something like this:

Code:

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

freeflow · 07-25-2010, 04:56 PM

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

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 · 07-26-2010, 07:37 AM

no probs

knew it was something along those lines you needed

cheers

07-23-2010, 06:34 PM	THREAD STARTER #1 (permalink)
freeflow NamePros Regular Join Date: Dec 2006 Posts: 236	PHP/MySQL Help 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” ????: NamePros.com http://www.namepros.com/programming/668411-php-mysql-help.html -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. Last edited by freeflow; 07-23-2010 at 07:33 PM.

07-24-2010, 08:10 AM	#2 (permalink)
smghost001 NamePros Member Join Date: Nov 2009 Posts: 142	$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 __________________ Scientific Calculator - SciCalculator.com Dns For Sale: Fuelcooler/s(.dot)com - RuralRiding(.dot)com - AttackTank(.dot)com - Foredoomed(.dot)com - SavingCalories(.dot)com - FairDealFinder(.dot)com

07-24-2010, 10:16 AM	#3 (permalink)
sdsinc Domains my Dominion Join Date: Aug 2005 Location: Web 1.0 Posts: 9,963	Something like this: Code: UPDATE [table] SET status=3 WHERE DATE_ADD([Timestamp column],INTERVAL [number of days] DAY) >= CURDATE() AND status=0 __________________ NameNewsletter.com - free lists of available domain names ZoneFiles.net (beta) - ccTLD and gTLD droplists

07-25-2010, 04:56 PM	THREAD STARTER #4 (permalink)
freeflow NamePros Regular Join Date: Dec 2006 Posts: 236	Thanks for your replies. They helped me find the right code. 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'"); }

07-26-2010, 07:37 AM	#5 (permalink)
smghost001 NamePros Member Join Date: Nov 2009 Posts: 142	no probs knew it was something along those lines you needed cheers __________________ Scientific Calculator - SciCalculator.com Dns For Sale: Fuelcooler/s(.dot)com - RuralRiding(.dot)com - AttackTank(.dot)com - Foredoomed(.dot)com - SavingCalories(.dot)com - FairDealFinder(.dot)com

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)