PHP Fill a Form from a Database: Newbie question please help

[newbiehacker]

HI how can you fill a form from a database? I have textboxes and need to pull the data from the database into the textboxes. I know how to create the querys but cant seem to figure out how to get the data into those boxes. PLEASE HELP

[legohead6]

heres a simple editing datascript! just replace the wrong info and add remve boxes... Edit: MAde extremely basic

[color=red][b]EDIT:2 added a } before the form[/b][/color]
[code]<?PHP
session_start();
$user=$_SESSION['user'];
$username="**********";
$password="*******";
$database="************";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query2="SELECT * FROM listings WHERE id='$id'";

$result2 = mysql_query($query2) or die ("Error in query: $query2. ".mysql_error());
while($row = mysql_fetch_row($result2)){

//All the field you want to show in text boxes
$title=$row[1];
$price=$row[2];
$des=$row[3];
}
//the form
echo "<form method=POST enctype='multipart/form-data'>Title<input type=text name=title value=$title><br><br>Price<input type=test name=price value=$price><br><br>$pic Description<br><textarea name=des>$des</textarea><br><input type=submit name=submit value=Update!></form>";


//the acculy editing of database
if(isset($_POST['submit'])){
$tit=$_POST['title'];
$pri=$_POST['price'];
$desc=$_POST['des'];

//the rows in the databse are case sensitive!

$query="UPDATE listings SET title='$tit', price='$pri', description='$desc' WHERE id='$lid'";
$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());
echo "<p><b>Listing Successfully Updated!</b></p>";
}
?>[/code]