Appointments.php:
<?php
if (isset($Delete)) {
include "data.inc.php";
$CONNECT = mysql_connect($DB_host, $DB_user, $DB_pass) or die(Mysql_error());
mysql_select_db($DB_name);
$insert = mysql_query("DELETE FROM $Table_appointments WHERE A_ID=\"$Delete\"") or die(mysql_error());
mysql_close($CONNECT);
header("location: appointments.php?Sec=schedule");
}
include "header.inc.php";
$Query = mysql_query("SELECT *, DATE_FORMAT(date, '%M %D, %Y')as new_date FROM $Table_appointments ORDER BY A_ID DESC") or die(mysql_error());
$Counted = mysql_num_rows($Query);
echo (" <a href=\"index.php\">Home</a> > Appointments<br><br>");
?>
<table width="95%" border="0" cellpadding="1" cellspacing="0" bgcolor="#000000" align="center">
<tr>
<td><table width="100%" border="0" cellpadding="8" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td><img src="images/myappointments.gif"><br><table width="98%" border="0" align="center" cellpadding="2" cellspacing="0">
<tr>
<td><table width="100%" border="0" cellpadding="1" cellspacing="0" bgcolor="#000000">
<tr>
<td><table width="100%" border="0" cellpadding="1" cellspacing="0" bgcolor="#6699FF">
<tr>
<td class="Title" style="padding='3'"> Appointments</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<?php
if ($Counted == 0) {
echo ("<tr><td align=center><strong>No appointments found</strong></td></tr>");
}
while($R=mysql_fetch_object($Query)) {
?>
<tr>
<td>
<table width="100%" border="0" align="center" cellpadding="1" cellspacing="0" bgcolor="#000000">
<tr>
<td><table width="100%" border="0" cellpadding="1" cellspacing="0" bgcolor="#FFFFCC">
<tr>
<td><table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr valign="top">
<td width="120"><strong>Time:</strong> <em><?= $R->time; ?></em><br><font size="1"><?= $R->new_date; ?></font></td>
<td> <strong><?= $R->type; ?>: </strong><br> <font size="1"><?= nl2br($R->notes); ?></font></td>
<td width="22"> <div align="center"><a href="appointments.php?Sec=schedule&Delete=<?= $R->A_ID; ?>"><img src="images/delete.gif" alt="Delete Task" width="16" height="16" border="0"></a></div></td>
</tr>
</table>
</td>
</tr>
</table></td>
</tr>
</table>
</td>
</tr>
<?php
}
?>
<tr>
<td><table width="100%" border="0" cellpadding="1" cellspacing="0" bgcolor="#000000">
<tr>
<td><table width="100%" border="0" cellpadding="1" cellspacing="0" bgcolor="#6699FF">
<tr>
<td height="10"><strong> </font></strong></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<?php
include "footer.inc.php";
?>
Other Organizers Scripts:
