display data from database in table form

[atika90]

how i want to display data from database to look like this :

 

 

 

<table width="633" height="224" border="1">

  <tr bgcolor="#999900">

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

    <td width="121">Course_name</td>

    <td width="83">session</td>

    <td width="83">start_date</td>

    <td width="83">end_date</td>

    <td width="83">notes</td>

    <td width="89">pre-req</td>

  </tr>

  <tr bgcolor="#6A7AEA">

    <td rowspan="2">1.</td>

    <td rowspan="2" bgcolor="#6A7AEA">Math</td>

    <td>1st session </td>

    <td>1 jan 11 </td>

    <td>6 jan 11 </td>

    <td rowspan="2"> </td>

    <td rowspan="2"><image icon that will link to the oter site> </td>

  </tr>

  <tr>

    <td bgcolor="#6A7AEA">2nd session </td>

    <td bgcolor="#6A7AEA">8 jan 11 </td>

    <td bgcolor="#6A7AEA">15 jan 11 </td>

  </tr>

  <tr>

    <td bgcolor="#0066CC">2.</td>

    <td bgcolor="#0066CC">English</td>

    <td bgcolor="#0066CC">1st session </td>

    <td bgcolor="#0066CC">1 feb 11 </td>

    <td bgcolor="#0066CC">6 feb 11 </td>

    <td bgcolor="#0066CC"> </td>

    <td bgcolor="#0066CC"><image icon that will link to the oter site></td>

  </tr>

  <tr>

    <td rowspan="2" bgcolor="#6A7AEA">3.</td>

    <td rowspan="2" bgcolor="#6A7AEA">Science</td>

    <td height="29" bgcolor="#6A7AEA">1st session </td>

    <td bgcolor="#6A7AEA">8 march 11 </td>

    <td bgcolor="#6A7AEA">15 march 11 </td>

    <td rowspan="2" bgcolor="#6A7AEA"> </td>

    <td rowspan="2" bgcolor="#6A7AEA"><image icon that will link to the oter site></td>

  </tr>

  <tr>

    <td bgcolor="#6A7AEA">2nd session</td>

    <td bgcolor="#6A7AEA">16 march 11 </td>

    <td bgcolor="#6A7AEA">21 march 11 </td>

  </tr>

</table>

 

 

** all the view data is called from database including the icon image

thanks...

 

[Eyewash01]

<?php
$sql = "SELECT * FROM stuff;";
$rs = mysql_query($sql);
while ($row = mysql_fetch_array($rs)){
	extract ($row);
	echo '<td>'.$example_field_name1.'</td>';
	echo '<td>'.$example_field_name2.'</td>';
}
?>

[atika90]

what is the fuction of line:

extract ($row);