onedumbcoder Posted June 9, 2009 Share Posted June 9, 2009 I have this update query that is not working right and im not sure why "UPDATE p, pp SET p.status='1' WHERE p.pp_id='$id' AND DATE_ADD(pp.due_date, INTERVAL 48 HOUR) < NOW()"; ending_date is in two days but this still changes the status of p to 1 when it shouldnt. it should only change the status of p to 1 after 48 hours past the due date Link to comment https://forums.phpfreaks.com/topic/161559-update-issue/ Share on other sites More sharing options...
Maq Posted June 9, 2009 Share Posted June 9, 2009 Echo out your query to see what you're actually executing. Link to comment https://forums.phpfreaks.com/topic/161559-update-issue/#findComment-852564 Share on other sites More sharing options...
Ken2k7 Posted June 11, 2009 Share Posted June 11, 2009 Shouldn't that less than sign be a greater than sign? If it's a less than sign, it would be a time in the past, right? Link to comment https://forums.phpfreaks.com/topic/161559-update-issue/#findComment-853477 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.