I'm stumped!!!!!!!!!!!!!

Anon

I have this calendar and it's supposed to print out the word "Activity" if they book an event on that day.

Everything works great except the query isn't finding the username. I did 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.

Anon

Here's my entire coding. I hope you can see something I don't. I've put large coments to direct your attention to the problem area.

Thanks,
Mike

<?PHP
session_start();
include ("dblib.inc");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<head>

<title>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
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>&nbsp;</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 will not appear
		$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>&nbsp;</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>

Mike wrote:

I have this calendar and it's supposed to print out the word "Activity" if they book an event on that day.

Anon

$query = "SELECT * FROM activities WHERE CUserName='$CUserName' AND ADay='$d' AND AMonth='$themonth' AND AYear='$y'";
print "$query";

If I got rid of everything after WHERE it would work.. For some reason I don't know why, but it happened to me using something else. The thing is I need the WHERE to query the DB...oh wellz, can someone help!

[deleted]

Your query is inside a function. Globally registered vars, such as session vars, don't exist in the scope of a function. You'll have to pass the username var to the function.