Need help updating fields with input textboxes

[flashx]

Hi ladies and gents,

 

Im new to PHP & mysql, so please go easy on me

 

I have connected my mysql database up to my php webpage but im having a bit of trouble gettin my head round dynamically displaying and updating a row of fields using input textboxes.

 

currently i have this:

$i=0;
while ($i < $num) {

$myname=mysql_result($result,$i,"firstname");
echo "<input type='text' name='name' value='$myname'><br/>";

$i++;
}

(the above displays all names in the firstname field)

 

my fields are as follows:

 

firstname, lastname, age, gender etc

 

so i guess my question is, how do i create a script that runs through each row and dynamically displays each field in a textbox which in turn is updatable by clicking a save button?

 

 

Any help would be much appreciated.

 

 

Cheers