Question of insert item in 'While'

[mrwhiteboy]

Hi all, I need some help. THanks.

I have 2 data base, member and list.
I made a table show my member list, and they have own textbox for units and price.

eg.(index.php)

<form name="form1" method="post" action="modify.php">
<?
$query=mysql_query("select * from member");
while (list($no,$id)=mysql_fetch_rows($query))
{
echo "<tr><td>".$id;
echo "<td><input type=text name=price>";
echo "<td><input type=text name=units>";
}
echo "<tr><td><input type=submit name=submit>";
?>

then I want insert member, price and units into the 'list',
How to define price and unit set to each member?

Thanks you so much. I thing about this over 4 days but can't solve.

[apulmca2k4]

your question is not clear.