Please I need urgent help

[dbnet]

Please help me with this:

with this code i have only fetched out the subjects and i need to fetch out value for the following too from the database

1. GRADE

2. Contious Assessment:

3. Exam Scores:

4. Exam Scores

5. Weighted Average:

6. Last Term Cummulative:

7. Cumulative  (c+d)/2:

8. Comment:

but now i can only get the foreach work for subject alone..

 

 

$l=mysql_query("SELECT * FROM result WHERE school_id='$id' AND student_reg_id='$st'") or die (mysql_error());

 

if (mysql_num_rows($l) > 0)

{

while ($row = mysql_fetch_array($l))

{//

$pwrlist[$row['ajax_result_id']]=$row['subject'];

//$

}

$numpwr = count($pwrlist);

$thresh = 3;

$maxcols = 18;

$cols = min($maxcols, (ceil(count($pwrlist)/$thresh)));

$percol = ceil(count($pwrlist)/$cols);

$powerchk = '';

$i = 0;

foreach ($pwrlist as $id => $pwr)

{

if (($i>0) && ($i%$percol == 0))

{

$powerchk .= "</td>\n<td valign='top'>";//echo "<br>";

}

 

 

$powerchk .= " <table width='280px' class='hovertable'>

 

                <tr>

                  <td width='251px' height='34' align='left' valign='middle' bgcolor='#D6DFEB'><span class='style19'><font size=2px>$pwr</font></span></td>

                  <td width='19px' align='left' valign='middle' bgcolor='#D6DFEB'><span class='style1'>GRADE:</span></td>

                  <td width='20px' align='left' valign='middle' bgcolor='#FFFFFF'><span class='style13'>B3</span></td>

                </tr>

                <tr>

                  <td height='34' colspan='3' align='left' valign='top' bgcolor='#FFFFFF'><span class='style20'>» (a) Contious Assessment: 80<br />

                    » (b) Exam Scores: 90<br />

                    » © Weighted Average: 168<br />

                    » (d) Last Term Cummulative: 78<br />

                    » (e) Cumulative  (c+d)/2: 123 </span></td>

                </tr>

                <tr>

                  <td height='20' colspan='3' align='left' valign='top' bgcolor='#FFFFFF'><span class='style17'>Comment: His is a responsible boy</span></td>

                </tr>

            </table><br>\n";

$i++;

}

 

}

[AyKay47]

not 100% sure as to what you are asking.. however if you need to grab relevant data from different tables you will want to use a JOIN

[dbnet]

Am not trying to get data from different tables but the same table where i got the subject from...since i use foreach to bring out the subject from the database it nw became difficult for me to fetch other data from the same table

[dbnet]

i have attached the template of what i want to achieve

 

[attachment deleted by admin]