to add a new filed:
1) Add the new column to the database table.
2) Update the WADAtbl_directorylistings recordset that is used to populate the page so that it returns the new column
3) Add a new text filed to the page, bind the initial value to the new column that was added to the recordset
4) edit the Update record server behavior to bind the new column to the new text filed.
to show an update successful message:
set the redirect in the update record behavior to pass an update=true querystring variable:
page.php?update=true
then you can use an if statement to show the message:
<?php if(isset($_GET['update']) && $_GET['update'] == "true") { ?>
<span style="color: green;">Updated Successfully</span>
<?php } ?>