keenej Posted January 13, 2009 Share Posted January 13, 2009 What IM trying to accomplish within loop is if date changes to a new date then reset some variables and calculate new totals for the next date. while (!$rs->EOF) { $tmpDATE=$rs->Fields('ProductionDate'); if($tmpDATE==$loopDATE){ }else{ echo "TEMP DATE " . $tmpDATE . "<BR>"; $loopDATE=$tmpDATE; echo "LOOP DATE " . $loopDATE . "<BR>"; } $rs->MoveNext(); } Quote Link to comment https://forums.phpfreaks.com/topic/140692-having-trouble-comparing-dates-within-sql-loop/ Share on other sites More sharing options...
keenej Posted January 13, 2009 Author Share Posted January 13, 2009 Sorry posted without rest of details. The above loop IM trying to pull for four different dates when the date changes the screen should print out the new date. Once I can get this to work the rest should be easy. Appreciate your help. Quote Link to comment https://forums.phpfreaks.com/topic/140692-having-trouble-comparing-dates-within-sql-loop/#findComment-736353 Share on other sites More sharing options...
keenej Posted January 13, 2009 Author Share Posted January 13, 2009 This issue is somewhat solved. I nested the code I need within a sql query that pull distinct dates and each time reset values there. Quote Link to comment https://forums.phpfreaks.com/topic/140692-having-trouble-comparing-dates-within-sql-loop/#findComment-736391 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.