I have this calendar and it's supposed to print out the word "Activity" if
there is an event booked on that day.
Everything works great except the query isn't finding the username. I did a
print "$CUserName is CUserName" and it works great - so I know I started my
session and it's accessible but when I put inside the query, it doesn't show
up. I tried passing it through the browser and passing the entire session
through the browser and still no dice. I also checked my php.ini file and
ALL of my globals are on.
Here's my coding, I really hope someone can help me figure this thing out.
Thanks,
Mike
<?PHP
session_start();
include ("dblib.inc");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>LDSAlberta.com: Personal Calendar</title>
<Link href="arial.css" rel="stylesheet" title="arial" type="text/css">
</head>
<body>
<img src="pics/logo.gif">
<BR>
<div align="center"><font size="4">Calendar of Events</font> <BR>
<hr>
<BR>
<?PHP
mk_drawCalendar($m,$y);
?></div>
<div align="center">
<?PHP
// Draw the Calendar
global $CUserName;
function mk_drawCalendar($m,$y)
{
if ((!$m) || (!$y))
{
$m = date("m",mktime());
$y = date("Y",mktime());
if ($m==1)
$themonth="jan";
else if ($m==2)
$themonth="feb";
else if ($m==3)
$themonth="mar";
else if ($m==4)
$themonth="apr";
else if ($m==5)
$themonth="may";
else if ($m==6)
$themonth="jun";
else if ($m==7)
$themonth="jul";
else if ($m==8)
$themonth="aug";
else if ($m==9)
$themonth="sept";
else if ($m==10)
$themonth="oct";
else if ($m==11)
$themonth="nov";
else if ($m==12)
$themonth="dec";
}
// get what weekday the first is on /
$tmpd = getdate(mktime(0,0,0,$m,1,$y));
$month = $tmpd["month"];
$firstwday= $tmpd["wday"];
$lastday = mk_getLastDayofMonth($m,$y);
?>
<font size=1>Click on date to see details</font>
<table cellpadding=2 cellspacing=0 border=1>
<tr>
<td colspan=7 bgcolor="#cccc99">
<table cellpadding=0 cellspacing=0 border=0 width="100%">
<tr>
<th width="100">
<a href="<?=$SCRIPT_NAME?>?m=<?=(($m-1)<1) ? 12 : $m-1
?>&y=<?=(($m-1)<1)
? $y-1 : $y ?>"><<</a>
</th>
<th><font size=2><?="$month $y"?></font></th>
<th width="100">
<a href="<?=$SCRIPT_NAME?>?m=<?=(($m+1)>12) ? 1 : $m+1
?>&y=<?=(($m+1)>12) ? $y+1 : $y ?>">>></a>
</th>
</tr>
</table>
</td>
</tr>
<tr>
<th width=100 class="tcell">Sunday</th>
<th width=100 class="tcell">Monday</th>
<th width=100 class="tcell">Tuesday </th>
<th width=100 class="tcell">Wednesday</th>
<th width=100 class="tcell">Thursday</th>
<th width=100 class="tcell">Friday</th>
<th width=100 class="tcell">Saturday</th>
</tr>
<?PHP
$d = 1;
$wday = $firstwday;
$firstweek = true;
//Loop Through to last day
while ( $d <= $lastday)
{
//blanks for first week
if ($firstweek) {
print "<tr>";
for ($i=1; $i<=$firstwday; $i++)
{ print "<th height=100 bgcolor=#CCCCCC><font
size=2> </font>
</th>"; }
$firstweek = false;
}
//checks for event
if($numrows>=1)
{
//Event exists
print "<td class='tcell' bgcolor=#CCCCCC valign=\"top\"
height=\"100\">
<a href=calendardetails.php?ADay=$d&AMonth=$themonth&AYear=$y
target=\"new_window\"><B>$d</b></a>
</td>";
}
else
{
//Event doesn't exist
print "<td class='tcell' bgcolor=#CCCCCC valign=\"top\"
height=\"100\">
<a href=calendardetails.php?ADay=$d&AMonth=$themonth&AYear=$y
target=\"new_window\"><B>$d</b></a>";
///////////////////////////////////////////////////////
// PROBLEM IS HERE!!!! CUserName doesn't show up
$eventrows = 0;
$query = "SELECT * FROM activities WHERE
CUserName='$CUserName' AND
ADay='$d' AND AMonth='$themonth' AND AYear='$y'";
print "<font size=-1>$query</font>";
//
///////////////////////////////////////////////////////
$result = mysql_query($query);
$eventrows = mysql_num_rows($result);
if($eventrows>=1)
print "Activity";
print "</td>";
}
$wday++;
$wday = $wday % 7;
$d++;
// Sunday start week with <tr>
if ($wday==0) { print "<th height=100 bgcolor=#ffffff><tr></th>"; }
//blanks for last week
if ($lastweek) {
print "<tr>";
for ($lastday=28; $tlastday<=31; $lastday++)
{
print "<th height=100 bgcolor=#AAAAAA>
</th><font size=2> </font>"; }
$lastweek = false;
}
}
?>
</tr></table>
<font size=1>Click on date to see details</font>
<br>
<?PHP
//end calendar Draw Function
}
//Show the last day of the month
function mk_getLastDayofMonth($mon,$year)
{
for ($tday=28; $tday <= 31; $tday++)
{
$tdate = getdate(mktime(0,0,0,$mon,$tday,$year));
if ($tdate["mon"] != $mon)
{ break; }
}
$tday--;
return $tday;
}
?>
</div>
</body>
</html>
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
