//$GLOBALS['nosidebar-right']=1;
if ( is_user_logged_in() ) {
$xc=0;
$link = mysql_connect("localhost","calendar1","Sonata21") or die(mysql_error());
mysql_select_db("calendar1") or die(mysql_error());
$d=date('y-m-d');
$pduessql=mysql_query("SELECT subject,description,end_date,catid FROM phpc_events INNER JOIN phpc_occurrences ON
phpc_events.eid=phpc_occurrences.eid WHERE subject like '%".$userdata->display_name."%' ORDER BY subject") or die(mysql_error());
//$pdues=mysql_fetch_array($pduessql);
$num_rows = mysql_num_rows($pduessql);
echo "date ". date('m-d-y')."
"; echo "Number Of Records ".$num_rows."
"; $tbl='Paid 3 days 1 Day Due '; echo $tbl."
"; while($row = mysql_fetch_array( $pduessql )) { if($row['catid']==3){$c="danger"; $fc="#FFFFFF";}//red if($row['catid']==2){$c="warning"; $fc="#000000"; }//yellow if($row['catid']==1){$c="success"; $fc="#000000";}//green if($row['catid']==4){$c="primary"; $fc="#FFFFFF"; }//black if($row['catid']==0){$c="default"; $fc="#FFFFFF"; }//black //echo '
'; echo '";
//echo $row['end_date']."
"; $xc=$xc+1; } } ?>
"; echo "Number Of Records ".$num_rows."
"; $tbl='Paid 3 days 1 Day Due '; echo $tbl."
"; while($row = mysql_fetch_array( $pduessql )) { if($row['catid']==3){$c="danger"; $fc="#FFFFFF";}//red if($row['catid']==2){$c="warning"; $fc="#000000"; }//yellow if($row['catid']==1){$c="success"; $fc="#000000";}//green if($row['catid']==4){$c="primary"; $fc="#FFFFFF"; }//black if($row['catid']==0){$c="default"; $fc="#FFFFFF"; }//black //echo '
'; echo '
';
echo $row['subject']."";
echo $ret;
$desc=str_replace("\n","
",$row['description']); echo ''.$desc."
";
echo "",$row['description']); echo ''.$desc."
"; $xc=$xc+1; } } ?>