|
Sample Code:
<![CDATA[
<?php
// For getting previous date to display date.
$query =mysql_query("select * from backup_history where
backup_date < '$displayDate' order by backup_date desc limit 1");
$totalrecords=mysql_num_rows($query);
if($totalrecords>0)
{
$row = mysql_fetch_assoc($query);
$previousDate= $row['backup_date'];
//echo $previousDate;
?>
<td>
<a href="index.php?displaydate=<?php echo $previousDate;?>">
<< </a>
</td>
<?php
}?>
<td><table><tr>
<td align="center">
<?php echo "Backup of " .date("l",strtotime($displayDate));?>
</td></tr>
<tr><td align="center">
<?php echo date(" F d, Y ",strtotime($displayDate));?>
</td>
</tr></table></td>
<?php
// For getting next Date to the Display Date.
$query =mysql_query("select * from backup_history where
backup_date > '$displayDate' order by backup_date asc limit 1");
$totalrecords=mysql_num_rows($query);
if($totalrecords>0)
{
$row = mysql_fetch_assoc($query);
$nextDate= $row['backup_date'];
?>
<td>
<a href="index.php?displaydate=<?php echo $nextDate;?>">
>> </a>
</td>
<?php
}
?>
]]>
|
