assign database result to iinput text box

[email protected] ("iccsi")
Newsgroups php.general
Message-ID <[email protected]>
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");
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.