function getAvailDates() { global $link, $limit, $offset; $dates = array(); $fullDates = array(); $tweetTotals = array(); $result = mysql_query("SELECT updatedTime FROM newswire_tb ORDER BY updatedTime DESC"); while ($row = mysql_fetch_assoc($result)) { if (_checkDate($row['updatedTime'], $dates) == 0) { $dates[] = _parseDate($row['updatedTime']); $fullDates[] = $row['updatedTime']; } } //mysql_free_result($result); //mysql_close($link); //echo 'working on it'; getTotals($fullDates); }
function getAvailDates() { global $link; $dates = array(); $fullDates = array(); $result = mysql_query("SELECT updatedTime FROM newswire_tb ORDER BY updatedTime DESC"); while ($row = mysql_fetch_assoc($result)) { if (_checkDate($row['updatedTime'], $dates) == 0) { $dates[] = _parseDate($row['updatedTime']); $fullDates[] = $row['updatedTime']; //$dates[] = $row['updatedTime']; } //echo "date: "._parseDate( $row['updatedTime'] )."<br>"; } for ($i = 0; $i < count($dates); $i++) { //echo 'selected date: '.$dates[$i]."<br>"; } mysql_free_result($result); mysql_close($link); outputXML($fullDates); }
$data['Date_IQ_Test'] = $candrow['WASI_date']; } else { $data['Date_IQ_Test'] = $candrow['DAS_date']; } // test the DB date if (empty($data['Date_IQ_Test']) || empty($data['Date_visit'])) { // if any of the dates is empty $data['DB_Window'] = "MI"; } else { // split the dates to test them $dateArray = explode('-', $data['Date_visit']); $dateOfVisit = array('Y' => $dateArray[0], 'M' => $dateArray[1], 'd' => $dateArray[2]); $dateArray = explode('-', $data['Date_IQ_Test']); $dateOfIQTest = array('Y' => $dateArray[0], 'M' => $dateArray[1], 'd' => $dateArray[2]); unset($dateArray); if (_checkDate($dateOfIQTest) == false || _checkDate($dateOfVisit) === false) { $data['DB_Window'] = "Date Error"; } else { // test the DB window - not applicable for V1 if (strtolower($data['Visit']) == 'v1') { $data['DB_Window'] = ""; } else { // compute the dates in months $data['DB_Window'] = abs($dateOfVisit['Y'] * 12 + $dateOfVisit['M'] - ($dateOfIQTest['Y'] * 12 + $dateOfIQTest['M'])); } } unset($dateOfIQTest); unset($dateOfVisit); } /* ** FEEDBACK status info