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 Quote 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. Quote 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? Quote Link to comment https://forums.phpfreaks.com/topic/161559-update-issue/#findComment-853477 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.