Hey all. Very Greenhorn coder here. Enough to have any idea where to look and to try things.

I am trying to get the below to go into two table

<p class="input">
<label for="username"><?php echo $this->translate('Username');?> <br class="hide" /></label>
<span class="field"><input type="text" name="username" id="username" value="<?php echo $this->username;?>" /></span>
<span class="addtext"><?php echo $this->baseUrl;?>username</span>
<p class="input">
<label for="firstname"><?php echo $this->translate('Screen Name');?> <br class="hide" /></label>
<span class="field"><input type="text" name="firstname" id="firstname" value="<?php echo $this->firstname;?>" /></span>

What I essentially want to happen is hide the Screen Name section, but have whatever is typed into the Username box, be auto-copied to the Screen Name box (while its hidden).

The other method that would work, would be to tell mySQL to copy anything from table A to table B. However, I am having more issues trying to figure out the mysql function for this, so thought I would try working on things from the front end.

Any ideas? Or am I way off on this?