In my table, I have three columns: task_name, start_date, and end_date. When printing out my calendar, I want to print a cell for each of those days with the task name in each cell. I'm trying to figure out the best way to do this. If someone has suggestions / tips, I would appreciate it greatly.
Right now, the query looks something like this:
$query = "SELECT task_name, DATE_FORMAT(start_date, '%e') AS sdate, start_date, entry_date FROM myTable WHERE start_date BETWEEN '2008-01-01' AND '2008-01-31'";
$result = mysql_query($query);
echo '<td height="75px">';
while($row = mysql_fetch_array($result)) {
if($onday == $row['sdate']) {
echo $row['entry_title'];
}
}
echo '</td>';