Ok so I have this script that I got off the Internet, which works. It has a place where you can query a database for data to fill in the dates on the calendar. So I made a query to search the database, however, nothing shows up on my calendar. I need a fresh set of eyes to look at my code to see if there is anything that I did wrong.
Here is my Code:
<?php
require('dbconnect.php');
$monthTitle = date('F');
$monthNum = date('n');
$year = date('Y');
/*CALENDAR FUNCTION*/
/* draws a calendar */
function draw_calendar($month,$year){
/* draw table */
$calendar = '<table cellpadding="0" cellspacing="0" class="calendar">';
/* table headings */
$headings = array('Sunday','Monday','Tuesday','Wednesday','Thursday','Friday','Saturday');
$calendar.= '<tr class="calendar-row"><td class="calendar-day-head">'.implode('</td><td class="calendar-day-head">',$headings).'</td></tr>';
/* days and weeks vars now ... */
$running_day = date('w',mktime(0,0,0,$month,1,$year));
$days_in_month = date('t',mktime(0,0,0,$month,1,$year));
$days_in_this_week = 1;
$day_counter = 0;
$dates_array = array();
/* row for week one */
$calendar.= '<tr class="calendar-row">';
/* print "blank" days until the first of the current week */
for($x = 0; $x < $running_day; $x++):
$calendar.= '<td class="calendar-day-np"> </td>';
$days_in_this_week++;
endfor;
/* keep going with days.... */
for($list_day = 1; $list_day <= $days_in_month; $list_day++):
$calendar.= '<td class="calendar-day">';
/* add in the day number */
$calendar.= '<div class="day-number">'.$list_day.'</div>';
/** QUERY THE DATABASE FOR AN ENTRY FOR THIS DAY !! IF MATCHES FOUND, PRINT THEM !! **/
$query = "SELECT * FROM eventDate WHERE mMonth = '$monthNum' AND mDay = '$list_day' AND mYear = '$year'";
$result = mysql_query($query) or die(mysql_error());
echo "Queried";
while($row = mysql_fetch_assoc($result))
{
$person = $row[Person];
$timeIn = $row[tIn];
$timeOut = $row[tOut];
$all = $person."<br />".$timeIn."<br />".$timeOut;
$calendar.= $all;
}
$calendar.= '</td>';
if($running_day == 6):
$calendar.= '</tr>';
if(($day_counter+1) != $days_in_month):
$calendar.= '<tr class="calendar-row">';
endif;
$running_day = -1;
$days_in_this_week = 0;
endif;
$days_in_this_week++; $running_day++; $day_counter++;
endfor;
/* finish the rest of the days in the week */
if($days_in_this_week < 8):
for($x = 1; $x <= (8 - $days_in_this_week); $x++):
$calendar.= '<td class="calendar-day-np"> </td>';
endfor;
endif;
/* final row */
$calendar.= '</tr>';
/* end the table */
$calendar.= '</table>';
/* all done, return result */
return $calendar;
}
/* Print out Calendar */
echo draw_calendar($monthNum,$year);
?>
Thanks in Advance
