So far i have::
$dbconn;
$query="SELECT * FROM phpmycal WHERE month='$mon' AND year='$year'";
$result=mysql_query($query);
$num=mysql_numrows($result);
echo "<table width=\"100%\" border=\"0\" id=\"display\">\n";
echo "<tr id=\"tbhead\"><td>Date:</td><td>Event Details</td><td></td></tr>";
$i=0;
while ($i < $num) {
$id=mysql_result($result,$i,"id");
$d=mysql_result($result,$i,"day");
$month=mysql_result($result,$i,"month");
$y=mysql_result($result,$i,"year");
$event=mysql_result($result,$i,"event");
?>
<tr>
<td id="date"><font face="Arial, Helvetica, sans-serif"><? echo $d."-".$month."-".$y; ?></font></td>
<td id="details"><font face="Arial, Helvetica, sans-serif"><? echo $event; ?></font></td>
<td id="link"><font face="Arial, Helvetica, sans-serif"><a href="javascript:popUp('event.php?id=<? print "$id"; ?>')">More Info.</a></font>
</tr>
<?php
$i++;
}
echo "</table>";
mysql_close();
?>
Which outputs all the stored data..
Other variables i have set are : $day $mon and $year.
how could i change this script so that it only gets the record if $day is greater than $d ??
TIA
RT
