HAVING TROUBLE COMPARING DATES WITHIN SQL LOOP

[keenej]

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(); }

[keenej]

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.

[keenej]

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.