here setQuery("SELECT daynote FROM my_tc_daynotes WHERE CURDATE() + 0 = yyyymmdd AND username='all'"); $dbArray = $database->loadAssocList(); $dbArray = $dbArray[0]; $todays_raid = $dbArray['daynote']; if(is_null($todays_raid)==true){ echo "No raid has been added for today"; } else { echo $todays_raid; } $number = date('j')-1; $result = mysql_query("SELECT template FROM my_tc_templates WHERE year = 2006 AND month = '08'") or die(mysql_error()); while ($row = mysql_fetch_array($result)) { $template = $row[template]; if($template{$number}=='F')$i++; } $i= $i-1; echo ""; echo ""; echo ""; echo ""; echo "

$i

" ?>