从动态创建的html表中获取某些列的数据

Question

my current problem is : I have a HTML table created "dynamically" according to how many rows brings back a mysql_query. The first column gets tha data from the query and the second column have a text field (see below):

<?php 
    $selApart = "SELECT idAPARTMENT FROM BUILDING, APARTMENT WHERE APARTMENT.BUILDING_ID = BUILDING.idBUILDING AND idBUILDING = '$building'";
    $res = mysql_query($selApart) or die("Could not execute query.");

?>
  <table width="244" border="0" cellspacing="0" id="hours_table">
    <tr>
      <td width="121">APARTMENT</td>
      <td width="119">HOURS</td>
    </tr>
<?php 
    $rcnt = 0;
    while($r = mysql_fetch_array($res)){
        $a = $r['idAPARTMENT'];
        $rcnt++;
        $rid = 'row'.$rcnt;
    ?>
    <tr>
      <td>'<?php echo $a?>'</td>
      <td id='<?php echo $rid?>'><input type="text" name="hours" id="hours" value="0"/></td>
    </tr>
<?php } ?>
<input type="submit" name="complete" id="complete" align="middle" value="INSERT"/>

After my table is "ready", I want to fill in my text fields and insert these values in an sql table. What I don't know is how I can get the value of each column through the id I set, sth like

if(isset($_POST['complete'])){
    for($i=0; $i<$rcnt; $i++){
       //INSERT INTO APARTMENT (idAPARTMENT, HOURS) VALUES ($a, **table.row.id**)
    }
}

Can someone help? Is this possible to be done? Thanks in advance!

Answer 1

He, thing you have to do is add $rid as name to text box, then just submit form and you will have them in $_POST["row"+$rid];

You can loop through every $_POST and if variable starts with row + num save it in db

foreach($_POST as $key => $value)
   //if $key starts with row execute your db save

I hope this helps