get data from dynamically created html table for certain columns

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!

Leave a Reply

*

Hire Me
Follow Me!
Search
Most Popular Articles & Pages
Because your vote is Important
Sorry, there are no polls available at the moment.
Categories