$date_time_array = getdate(time());

$last_month = $date_time_array["month"];

$this_year  = $date_time_array["year"];

$last_mon   = $date_time_array["mon"];



$date = mktime(0,0,0,$last_mon,1,$this_year); //The get's the first of March 2009
$links = array();
$newstamp = time() - 3600;
$cpc = 0;
$cpm = 0;
$click = 0;

for($n=1;$n <= date('t',$date);$n++){



$thisdate = $this_year.'-'.$last_mon.'-'.str_pad($n, 2, '0', STR_PAD_LEFT );

$sql = "select * from pub_st_daily where  user='$user' && STR_TO_DATE(pdate,'%Y-%m-%d') = '$thisdate'  ";