mysql_connect ("localhost", "web", "guest") or die("Unable to connect to SQL server"); mysql_select_db("abbott") or die("Unable to select database"); ?>
Select a letter to get info.
----------------------------------- $dates = mysql_query("select id,date from letters") or die ("Unable to retrieve letters"); while ($item = mysql_fetch_array($dates)) { ?>
echo $item['date']; } ?>
$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); ?>
echo $title[$column]; ?>
} ?>
Actual Text of the letter
echo stripslashes($letter['actual']); ?>