Topic awaiting preservation: Mysql and php with multiple entrys (Page 1 of 1)

Ok I have a database wit hthe coloums Rank,Name,Block,Home, ID

now in my adminstration panel I pull out everyone who 's on the same block and have a form the form has there name,block,rank,home in a editable input field,
a row for each person so the entrys the admin would like to change can be changed and the others can be left the same and the user can simply press 'update' now..

too get my multiple lines of inputs im using this code,

$query =  mysql_query("SELECT * FROM staff WHERE block = '$block' ORDER BY 'block'") or die(mysql_error());



print "<table>";

print "<form action=\"$_SERVER[PHP_SELF]?block=$_GET[block]\" method=\"post\">";

  while($data = mysql_fetch_array($query)){

?>

   <tr>

  <td><input type="text" name="name" value="<?php print $data['name']; ?>"></td>

  <td><input type="text" name="homeurl" value="<?php print $data['home'];?>"></td>

  <td><input type="text" name="block" value="<?php print $data['block'];?>"></td>

  <td><input type="text" name="block" value="<?php print $data['rank'];?>">

   <input type="hidden" name="id" value="<?php print $data['id']; ?>"></td>

  </tr>

<?

}

print "<tr>\n<td><input type=\"submit\" value=\"submit\" name=\"submit\"></td>\n</tr>\n";

print "</form>";

print "</table>";

Now. . how do I insert all the data back into the table the easiest with out re-writing over anything else? keeping the id's wit hthe relivant posts etc.. I really cant seem to figure it out i've tried multiple things.. but its just not happening for me

can some one please help me

Trigger

The issue here is mainly an HTML one.

You can't have input text fields with the same name otherwise you're going to break your form. (The last entry clobbers all the rest I believe ).





.:[ Never resist a perfect moment ]:.

Rhather than use a hidden field to state the ID, I would append the ID to the name of each field. That way, each input has a unique name, and you can parse the name string to get the ID when entering the info back in to the database.

so, for each input, the name would be (for example) name_00037, rank_00037, etc....

How would I then incorporate the updateing of table... in one query then?
I mean considering I'll be updateing the same coloums multiple times.

you can't. You'll have to make serveral update queries.

yeah, run a loop to query the DB for each ID.