assign database result to iinput text box

I have following html code to show my input text box and php to connect server and select result from database server. I would like to know how I can I use php to assign the value to my input text. Your help and information is great appreciated, Regards, Iccsi, <INPUT type="text" name="Mytxt" id="MytextID" /> <?php $username = "root"; $password = "myPassword"; $hostname = "localhost"; //connection to the database $dbhandle = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL"); echo "Connected to MySQL<br>"; //select a database to work with $selected = mysql_select_db("iccsimd",$dbhandle) or die("Could not select aerver"); //execute the SQL query and return records $result = mysql_query("SELECT invid, invdate, note, amount FROM invheader");