How to set the value of a field to the database content and then the validated entry?
Here is a standard text input field for our INSERT form which displays the data entered by the user should validation fail:
<input name="FRcompanyTITLE" type="text" required class="form-control" id="FRcompanyTITLE" tabindex="1" value="<?php echo(ValidatedField("addcompany_937","FRcompanyTITLE")) ?>">
For our UPDATE form though I need the value to, initially, be the data from the recordset:
<?php echo($rsEDITCOMPANY->getColumnVal("FRcompanyTITLE")); ?>
...but upon validation, should any validation fail, I need it to reflect any changes that the user has made.
Can I combine the validation and recordset data for the input fields value? Would appreciate an example, if indeed it's possible.