getting mysql data in table..!

[subash85]

frens.. i would need help in getting the mysql data in my html table...

i have table where i would like to get data from mysql in the table below.. their is A | B |C|D|E|F|G|H|I|J| these are example in this table but the real data is in data base,  in mysql data are in table items with 'itemcode' and i would like to populate that data in table.. and below their is checkbox where we can check the box and send it to the mysql in itemcount from costumer as in 'itemcount' table in mysql... and below their is 'add more' which will work and adding more rows... so that we can add more data colums below with text box and check as it has now..

 

can any one help me about this stuff....

 

<table width="700" border="0" cellpadding="0" cellspacing="0">

  <tr>

    <th width="47" scope="col"> </th>

    <th width="237" scope="col"> </th>

    <th colspan="10" scope="col">Products Name</th>

  </tr>

  <tr>

    <td>S.N. </td>

    <td>Name</td>

    <td width="40">A</td>

    <td width="40">B</td>

    <td width="40">C</td>

    <td width="40">D</td>

    <td width="35">E</td>

    <td width="45">F</td>

    <td width="40">G</td>

    <td width="40">H</td>

    <td width="40">I</td>

    <td width="56">J</td>

  </tr>

  <tr>

    <td> </td>

    <td><form id="form1" name="form1" method="post" action="">

      <label>

        <input type="text" name="textfield" id="textfield" />

      </label>

    </form></td>

    <td><form id="form2" name="form2" method="post" action="">

      <label>

        <input type="checkbox" name="checkbox" id="checkbox" />

      </label>

    </form></td>

    <td><input type="checkbox" name="checkbox2" id="checkbox2" /></td>

    <td><input type="checkbox" name="checkbox3" id="checkbox3" /></td>

    <td><input type="checkbox" name="checkbox4" id="checkbox4" /></td>

    <td><input type="checkbox" name="checkbox5" id="checkbox5" /></td>

    <td><input type="checkbox" name="checkbox6" id="checkbox6" /></td>

    <td><input type="checkbox" name="checkbox7" id="checkbox7" /></td>

    <td><input type="checkbox" name="checkbox8" id="checkbox8" /></td>

    <td><input type="checkbox" name="checkbox9" id="checkbox9" /></td>

    <td><input type="checkbox" name="checkbox10" id="checkbox10" /></td>

  </tr>

</table>

  <input type="submit" name="button" id="button" value="Add More" />

<input type="submit" name="button" id="button" value="Submit Data" />

  </label>

 

 

here is my sql table where i got data

 

CREATE TABLE `products` (

  `id` int(11) NOT NULL auto_increment,

  `pname` text NOT NULL,

  `pcode` text NOT NULL,

  `packing` text NOT NULL,

  `division` varchar(100) NOT NULL,

  PRIMARY KEY  (`id`)

) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

 

i juz need to fetch data of pcode in that table in place of A|B|C|D|E|F|G|H|I|J..

hope to get help from you all fren...