PHP - Showing A Month From A Selection Of Dates.

How can i add dates from the previous / next month to the calendar for this calendar script? id like it to appear so its like:

28 29 30 31 1 2 3 4 5 6 etc.. then at the end 29 30 31 1 2 3 etc...


function av_calendar () {
$monthNames = Array("January", "February", "March", "April", "May", "June", "July", 
"August", "September", "October", "November", "December");
if (!isset($_REQUEST["sm"])) $_REQUEST["sm"] = date("n");
if (!isset($_REQUEST["sy"])) $_REQUEST["sy"] = date("Y");
$cMonth = $_REQUEST["sm"];
$cYear = $_REQUEST["sy"];

$prev_year = $cYear;
$next_year = $cYear;
$prev_month = $cMonth-1;
$next_month = $cMonth+1;

if ($prev_month == 0 ) {
$prev_month = 12;
$prev_year = $cYear - 1;
}
if ($next_month == 13 ) {
$next_month = 1;
$next_year = $cYear + 1;
}
//
$today = date('d');
echo '
<div class="head">
<h1>'.$monthNames[$cMonth-1].' '.$cYear.'</h1>
</div>
<div class="blockitem2">
<table width="100%" class="calendar" style="margin-left:-10px;" border="0" cellpadding="2" cellspacing="2">
<tr style="font-size:20px">
<th align="center"><strong>S</strong></th>
<th align="center"><strong>M</strong></th>
<th align="center"><strong>T</strong></th>
<th align="center"><strong>W</strong></th>
<th align="center"><strong>T</strong></th>
<th align="center"><strong>F</strong></th>
<th align="center"><strong>S</strong></th>
</tr> ';
$timestamp = mktime(0,0,0,$cMonth,1,$cYear);
$maxday = date("t",$timestamp);
$thismonth = getdate ($timestamp);
$startday = $thismonth['wday'];
$sy = date("Y",$timestamp);
$sm = date("m",$timestamp);
$sd = date("d",$timestamp);


for ($i=0; $i<($maxday+$startday); $i++) {
$day = ($i - $startday + 1);


if(($i % 7) == 0 ) { echo "<tr>\n"; }
if($i < $startday) { echo "<td></td>\n";
} else {
$now = "$sy-$sm-$day 00:00:00";
$then = "$sy-$sm-$day 23:59:59";
$sql = "SELECT av_episodes.id,av_episodes.date FROM av_episodes WHERE date between UNIX_TIMESTAMP('$now') AND UNIX_TIMESTAMP('$then')";
$query = exec_mysql_query($sql)  or die(mysql_error());
$rows = mysql_num_rows($query);
$nowurl = "$sy/$sm/$day/";

if(!empty($rows)) {
echo "<td class='dates' align='center' valign='middle' height='20px'><b><a href='".SITE_URL."updates/".$nowurl."'>". add_nulls($day) . "</a></b>";
} else { 
echo "<td class='datesInactive' align='center' valign='middle' height='20px'>". add_nulls($day) . "";
}
echo "</td>\n";





if(($i % 7) == 6 ) {echo "</tr>\n"; }



}
}
echo '</table></div>
';

I'm trying to get a bar graph from total number of hit on a month to month basis.

Everything works out find, except the bar graph is only showing 1 month, not everything that's being pulled out of the db.

Can anybody look and see what I'm doing wrong?

Code: [Select]
$userid = '44';
$t_month = date("Y-m-d h:i:s");
$y_month = date("Y-m-d h:i:s", strtotime("-1 Year"));

//Grabs Unique Visitors to App Page
$query = "SELECT CONCAT_WS(' ', YEAR(date), MONTHNAME(date)) AS RptDate, COUNT(DISTINCT referrer) 'referrer'
FROM app_analytics
WHERE appid = $userid
AND date BETWEEN '" .$y_month."'  AND  '" .$t_month."'
GROUP BY CONCAT_WS(' ', YEAR(date), MONTHNAME(date))
ORDER BY YEAR(date), MONTH(date)";

    $result = mysql_query($query) or die(mysql_error());       
        //$totals = array();
        while($row = mysql_fetch_array( $result )){
           
            $months = date("M", strtotime($row['RptDate']));
            $ip = $row['referrer']; 
             
           $values = array("$months" => $ip);
     
    $img_width=450;
$img_height=300;
$margins=20;

 
# ---- Find the size of graph by substracting the size of borders
$graph_width=$img_width - $margins * 2;
$graph_height=$img_height - $margins * 2;
$img=imagecreate($img_width,$img_height);

 
$bar_width=20;
$total_bars=count($values);
$gap= ($graph_width- $total_bars * $bar_width ) / ($total_bars +1);

 
# -------  Define Colors ----------------
$bar_color=imagecolorallocate($img,0,64,128);
$background_color=imagecolorallocate($img,240,240,255);
$border_color=imagecolorallocate($img,200,200,200);
$line_color=imagecolorallocate($img,220,220,220);
 
# ------ Create the border around the graph ------

imagefilledrectangle($img,1,1,$img_width-2,$img_height-2,$border_color);
imagefilledrectangle($img,$margins,$margins,$img_width-1-$margins,$img_height-1-$margins,$background_color);

 
# ------- Max value is required to adjust the scale -------
$max_value=max($values);
$ratio= $graph_height/$max_value;

 
# -------- Create scale and draw horizontal lines  --------
$horizontal_lines=20;
$horizontal_gap=$graph_height/$horizontal_lines;

for($i=1;$i<=$horizontal_lines;$i++){
$y=$img_height - $margins - $horizontal_gap * $i ;
imageline($img,$margins,$y,$img_width-$margins,$y,$line_color);
$v=intval($horizontal_gap * $i /$ratio);
imagestring($img,0,5,$y-5,$v,$bar_color);

}
 
 
# ----------- Draw the bars here ------
for($i=0;$i< $total_bars; $i++){
# ------ Extract key and value pair from the current pointer position
list($key,$value)=each($values);
$x1= $margins + $gap + $i * ($gap+$bar_width) ;
$x2= $x1 + $bar_width;
$y1=$margins +$graph_height- intval($value * $ratio) ;
$y2=$img_height-$margins;
imagestring($img,0,$x1+3,$y1-10,$value,$bar_color);
imagestring($img,0,$x1+3,$img_height-15,$key,$bar_color);
imagefilledrectangle($img,$x1,$y1,$x2,$y2,$bar_color);
}
 
header("Content-type:image/png");
imagepng($img);
 } 

Thanks in advance

My db:

CREATE TABLE `tb_event` (
  `id` tinyint(4) NOT NULL auto_increment,
  `t_date` date default NULL,
  `t_event` varchar(75) default NULL,
  `t_place` varchar(75) default NULL,
  `t_content` text,
  PRIMARY KEY  (`id`)
)

Records:
1, '2011-01-09', 'event 1', ...
2, '2011-05-12', 'event 2', ...
3, '2011-09-20', 'event 3', ...

-------

My code he

<?
$now    = date("Y-m-d");
...
...
SELECT * FROM tb_acara WHERE t_tanggal >= $now
...
...
?>

It will show all records..
I change >= with <= it didn't show anything

-------

My goal is:
I only want to show the event which in September (month of 9) on record number 3

Can you help me please guys??
Thanks

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Untitled Document</title>
</head>

<body>
 <?php
 //MySQL Database Connect
 include 'sqlconnect.php'; 
?>

<select name="aktivitet" id="aktivitet">
<?php 
 //MySQL Database Connect
 include 'sqlconnect.php'; 
$sql = mysql_query("SELECT title FROM aktiviteter");
while ($row = mysql_fetch_array($sql)){
echo "<option value=\"owner1\">" . $row['title'] . "</option>";
}
?>
</select>
</body>
</html>

why dosnt this work?,   if you cant see what i want to happen, ill post an explaination  

Trying to get the below to generate the month in word form from a numeric entry in a database.
Code: [Select]
elseif($_GET['rma']=="calander"){
$sql101010="SELECT DISTINCT rma_year_issued FROM $tbl_name4 ORDER BY rma_year_issued";
$result101010=mysql_query($sql101010);
while($row101010=mysql_fetch_array($result101010)){
extract($row101010);
$content.='<a href="./acp_admincp.php?rma=calander&year='.$rma_year_issued.'">'.$rma_year_issued.'</a>
<br />';
}

if(isset($_GET['year'])){
$logout.=' | <a href="./acp_admincp.php?rma=calander">Back to RMA Calander</a>';
$rma_year_issued=$_GET['year'];
$sql111010="SELECT DISTINCT rma_month_issued FROM $tbl_name4 WHERE rma_year_issued='$rma_year_issued' ORDER BY rma_month_issued";
$result111010=mysql_query($sql111010);
while($row111010=mysql_fetch_array($result111010)){
extract($row111010);
$months = array('Janurary', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December');
for($i=0; $i <=11; $i++){
if($rma_month_issued=$i){
$rma_month_issued2=$months[$i];
}
}
$content="";
$content.='<a href="./acp_admincp.php?rma=calander&year='.$rma_year_issued.'&month='.$rma_month_issued.'">'.$rma_month_issued2.'</a>
<br />';

}
}
}

Basically in the data base I may have 2,5,7 under the year 2011.

I want to get the numeric months into words for use in the text of the link.

The above is returning December even though the entry in the database is 5.