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 times_letters") or die("Show failed.");
while ($column = mysql_fetch_array($columns)) {
$updatefield = $column['Field'];
$newdata = $$updatefield;
$query = "update times_letters SET $updatefield='$newdata' where id='$id'";
mysql_query($query) or die("Insert Failed!");
}
}
?>
$searchlist = mysql_query("select result from sbuffer where id='$searchid'");
$searchitem = mysql_fetch_array($searchlist);
$searchitem = explode(",",$searchitem['result']);
while($elt = current($searchitem)) {
if ($elt == $id) {
$after = next($searchitem);
break;
}
$before = $elt;
next($searchitem);
}
?>
$search = trim($search);
$searches = explode("%", $search);
$letters = mysql_query("select * from times_letters where id='$id'");
$titles = mysql_query("select * from times_titles 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);
?>
echo $title[$column]; ?> |
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;
} ?>
|
} ?>
$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") ?>