[RESOLVED] Loading a row of data?

[gszauer]

I have 2 files, first file allows user to select a row (depending on the row number) and the second should allow the user to edit the row (this is where i have the problem)
First is modofy.php

<form action="modofy1.php" method="post" enctype="multipart/form-data">
<?php
	$location = "localhost"; 
	$username = "program"; 
	$password = "*******"; 
	$database = "program_program"; 
	mysql_connect($hostname,$username, $password) OR DIE (" ");
	mysql_select_db($database); 
	$conn = @mysql_connect($location,$username,$password); 
	mysql_select_db($database,$conn) or die ("Could not open database"); 
	$result = mysql_query('SELECT id, address FROM db_x') or exit(mysql_error()); 
echo '<select name="list">'; 
while ($row = mysql_fetch_assoc($result)) 
{ 
    echo '<option value="' . $row['id'] . '">' . $row['address'] . '</option>'; 
} 
echo '</select>';
?>
 <input type="submit" value="Modofy" />
</form>

Now modofy.php has posted the id variable to modofy1.php,
here is modofy1.php

<?php
$location = "localhost"; 
$username = "program"; 
$password = "*******"; 
$database = "program_program"; 
$id = $_POST["list"];

mysql_connect($hostname,$username, $password) OR DIE (" ");
mysql_select_db($database); 
$conn = @mysql_connect($location,$username,$password); 

mysql_select_db($database,$conn) or die ("Could not open database"); 
?>

How can i load all the variables from the row into this php file?
My columns are
id
sold
price
address
description
tn
p1, p2, p3, p4, p5, p6, p7, p8, p9, and p10
Any help is greatly appriciated, and thank you wery mutch for your time!
~Gabor

[herve]

<?php
$location = "localhost";
$username = "program";
$password = "*******";
$database = "program_program";
$id = $_POST["list"];

mysql_connect($hostname,$username, $password) OR DIE (" ");
mysql_select_db($database);
$conn = @mysql_connect($location,$username,$password);

mysql_select_db($database,$conn) or die ("Could not open database");

$result = mysql_query('SELECT id,sold,price,address,description,tn, p1, p2, p3, p4, p5, p6, p7, p8, p9, p10

FROM db_x
WHERE id='$id'') or exit(mysql_error());

list ($id,$sold,$price,$address,$description,$tn,$p1,$p2,$p3,$p4,$p5,$p6,$p7,$p8,$p9,$p10) = mysql_fetch_array($result);

print "id=$id <br>\n";
print "sold=$sold <br>\n";
print "address=$address <br>\n";
....

?>

[gszauer]

oh, i see thank you sooooo mutch