mysql_connect ("localhost", "web", "guest")
or die("Unable to connect to SQL server");
mysql_select_db("abbott") or die("Unable to select database");
?>
if ($alter == "true") {
$columns = mysql_query("show columns from letters") or die("Show failed.");
while ($column = mysql_fetch_array($columns)) {
$updatefield = $column['Field'];
$newdata = $$updatefield;
$query = "update letters SET $updatefield='$newdata' where id='$id'";
mysql_query($query) or die("Insert Failed!");
}
}
?>
$search = trim($search);
$searches = explode("%", $search);
$letters = mysql_query("select * from letters where id='$id'");
$titles = mysql_query("select * from letters where id='1'");
$title = mysql_fetch_array($titles);
$letter = mysql_fetch_array($letters);
$fields = mysql_num_fields($titles);
for ($i=1; $i<($fields - 1); $i++) {
$column = mysql_field_name($titles, $i);
?>
if ($title[$column] != NULL){ echo $title[$column];}
else { echo "Alternate Date Format";} ?> |
if ($column == url and $letter[$column] != null) { ?>
Online text of letter
} else {
$result = stripslashes($letter[$column]);
if ($search != null) {
while($elt = current($searches)) {
$result = eregi_replace("($elt)","\\1",$result);
next($searches);
}
reset($searches);
}
echo $result;
if ($result == "") { echo "None"; }
} ?>
|
} ?>
$text = $letter['actual'];
if ($text != null) {
$trans = array("\n" => " ");
$text = strtr($text,$trans);
if ($search != null) {
while($elt = current($searches)) {
$text = eregi_replace("($elt)","\\1",$text);
next($searches);
}
}?>
Actual Text of the letter |
echo stripslashes($text); ?> |
} ?>
|
virtual("../bottom.txt") ?>